What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 60652In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 21652How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)
5 9081A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?
8 10071Post New Infosys SQL Server Interview Questions
Do you know the use of fflush() function?
what are list types?
What are class types in java?
What is the material consumption- cement,sand,tiles etc for Toilet dado?
What is @controller in spring boot? : Spring Boot
What is purpose of __init__ in class ? Is it necessary to use __init__ while creating a class ?
Where is autoshape in word?
Name the tables used for storing the event linkages ?
What is overdraft?
How do I filter in sql profiler?
Explain difficulties in nlu?
Have you purchased any product from Amazon.in?
How to restrict a member of a class from inheriting by its sub classes?
Do I need to have pi to use sap fscm credit management?
Is it possible to have a static indexer in c#?