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 difference between mysql_connect and mysql_pconnect?

557

What are mysql functions?

497

How do you determine the location of mysql data directory?

495

Is mysql owned by oracle?

541

change column name and make a unique column so we get no dupes.

506

Where is mysql used?

524

What is a table schema?

540

How do I edit a table in mysql?

497

What are the advantages of mysql in comparison to oracle?

553

How can you add and remove any column of a table?

527

How to return query output in html format?

533

How do I connect to a database in mysql workbench?

552

How many sql dml commands are supported by 'mysql'?

475

What is the full form of mysql?

519

How to create a trigger in mysql?

502