What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 63755In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 23588How 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 10938A 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 12748Post New Infosys SQL Server Interview Questions
How do you create customer account group?
Element a is a nonmetal with an electronegativity value of 3.0 and element b is a nonmetal with an electronegativity value of 2.5. What kind of bonding will occur between these two elements?
can anyone help me regarding testing patterns?
What is private procedure oracle?
i need test cases for defect maganement tools
what is the key purpose of using layers in a timeline? : Adobe flash
Who is debtor purchaser
How we can call a model from view in cakephp?
Who discovered the x-radiation?
Where we have to specify the teardown time in one operation?
What Is Ppf?
Is hibernate a tool or framework?
How to display or know if the value entered contains records or not?
How do I make my wordpress page visible?
What is meant by vector graphic animation?