What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 63971In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 23714How 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 11074A 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 12904Post New Infosys SQL Server Interview Questions
Difference interview global option set vs normal option set field in crm.
By default what is the prefix Joomla have?
What is session tracking?
Can we create exe file in java?
Is there a version of Merge for Linux?
What is dynamic xpath?
How much ram does windows 10 really need?
Write the analogous electrical elements in force current analogy for the elements of mechanical translational system.
What is a Balance Sheet & Profit & Loss Account?
what is base time , how can we base time your doc"s ?
Which elements constitute the administrative personnel structure?
Where is dhtml used?
In which table collections errors are stored.
Explain how would you describe your attitude? : insurance cold calling
What is executive accounting?