alter ignore table <tablename> add unique key (field1,field2,....);

how to delete duplicate rows in sql server 2005?

Question Posted / balaji

Answer Posted / balaji

alter ignore table <tablename> add unique key
(field1,field2,....);

Is This Answer Correct ?

1 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Which is faster mongodb or mysql?

897

Where is mysql used?

997

How many rows can mysql handle?

944

What is the difference between sql and mysql and oracle?

894

What is the limit of mysql database?

962

How can you count the total number of records of any table?

923

How to show table names with 'mysqlshow'?

1040

What do ddl, dml, and dcl stand for?

915

How do I make an action query?

936

Is pdo faster than mysqli?

895

How do I find the database name in mysql?

955

List some comparisons operators used in mysql?

987

How do I transfer data from one database to another in mysql?

905

How to include character strings in sql statements?

989

How do I find my mysql username and password?

961