how to delete duplicate rows in sql server 2005?
Answers were Sorted based on User's Feedback
Answer / balaji
alter ignore table <tablename> add unique key
(field1,field2,....);
Is This Answer Correct ? | 1 Yes | 9 No |
How to display nth highest salary from a table in a mysql query?
Is microsoft sql same as mysql?
What is the difference between primary key and candidate key?
How do you login to MySql using Unix shell?
Where is the mysql config file?
What is the return type of mysqli_query?
What is difference between pdo and mysqli?
How many types of indexes are there in mysql?
What is use of mysql?
What are CSV tables?
What is truncate command?
Explain Normalization concept?