What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 63758In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 23592How 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 10941A 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 12749Post New Infosys SQL Server Interview Questions
What is disconnected data architecture in c#?
Is xsd xml?
What is the advantage of oop over procedural language?
What is the tradeoff between using an unordered array versus an ordered array?
How can you reduce noise of an image?
What is meant by central administration?
Describe the two types of formbeans.
What is the description for syntax errors?
details about managerial effectiveness
Why credit suisse?
What is use of acquisition reports?
What is jms template?
How can I tell if a ftp port is open?
Explain socket programming in perl?
Define the Internet of Things (IoT) Function in Azure Cloud Service?