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

What is pragma autonomous_transaction?

827

How to delete a database from mysql server.

994

How many rows can be inserted in mysql at a time?

973

What is the difference between float and double?

1064

How to returns the columns and column information pertaining to the designated table.

983

How can you retrieve a portion of any column value by using a select query?

877

What is timestamp in mysql?

955

What is the difference between mysql_connect and mysqli_connect?

917

Why mysql is so popular?

918

How to create a new table in mysql?

997

why not null is not allowed at table level

2717

What is current version of mysql?

921

How do I quit mysql?

877

How do I exit mysql?

870

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1089