What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 62028In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 22571How 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 9974A 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 11357Post New Infosys SQL Server Interview Questions
In web logic how are new threads assigned?
Differentiate between library vs list.
Explain sub procedure of vbscript.
How to create facelets templates?
What is the use of @viewchild?
How do I connect to postgresql remotely?
Explain briefly what is Action in Apache Spark? How is final result generated using an action?
what question do you think is important question you have been ask?
What does sap netweaver application server offers?
Is learning linux worth it?
How to isolate prokaryotic mRNA
• What is depreciation and the method?
what is the relevance of computer science to business management
How can be determining the size of the log files?
What is eventemitter in angular?