What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 64049In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 23748How 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 11139A 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 12961Post New Infosys SQL Server Interview Questions
What is tap in angular?
Describe the use of Paint Bucket Tool and its Shortcut Key?
What is main thread in c#?
How do we implement inheritance in c++?
What is a dbrm in db2?
What are the business benefits involved in cloud architecture?
Dry type transformers
what is virtual directory in iis? : Windows server 2003
What do mean by Computerization of accounts
What actions are performed when a function is called?
which protection used in power plant?
whats new about truncate in sql server 2008?
How can i read the data in bar code form directly into sap i.e. without being uploading it to TXT file and then uploading to SAP.
What is the use of java?
What is the difference between a statement and an expression in ruby?