What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 60576In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 21585How 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 9020A 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 10014Post New Infosys SQL Server Interview Questions
Who is founders of Google?
What do you know about yarn?
Do ssd ever fail?
SPRO path for order, confirmation or requirement class.
What is a dequeue?
What is webmaster tool in seo?
What is the maximum of key fields and search fields allowed in a segment?
How do I design for backward compatibility using style sheets?
Can I kill rundll32 exe?
What are four types of turbine seals?
How do we calculate the power of centrifugal pump?
What are scriptable objects?
What is the difference between struct and typedef struct in c?
What are advantages of xml?
What is drupal language?