What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 63748In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 23582How 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 10934A 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 12738Post New Infosys SQL Server Interview Questions
How install magento step by step?
Is string primitive?
What do bitwise operators do?
What is a cookie What is the difference between session and cookie
How would you describe the experience of working at Allstate?
How to Get property information ?
What are the differences between primary key and unique key?
What is a copy constructor in c#?
how does sap hana support massively parallel processing?
Why do you want to join Honeywell ?
WHAT IS THE DIFFERENCE BETWEEN BIIS-B AND BISS-C INTERFACE
Explain is web server load balancing supported with peopletools 8.4?
what is the role of DataContext classes in LINQ?
How will you design an email spam filter?
How would you explain a kernel to a non-technical person?