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

In which format data is stored in mysql database?

1049

What is mysql procedure?

977

Write a query to display current date and time?

975

How to find second highest salary from a table?

1061

What is slow query log in mysql?

1158

How to create trigger in mysql phpmyadmin?

1184

How can I change database in mysql?

949

What is mysql url?

920

Is mysql a nosql database?

1214

How do I restore a database in mysql workbench?

1070

How to make a column bigger and delete unique from table.

1037

Is mysql easy to learn?

981

How to get current MySQL version?

1149

What is 'mysqlimport'?

983

How do I completely remove mysql from windows?

1023