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 are the technical features of MySQL?

995

What is tee command in mysql?

928

What is the difference between unix timestamp and mysql timestamp?

1041

What causes mysql too many connections?

930

What is a result set object?

930

why not null is not allowed at table level

2736

What is processlist in mysql?

984

What is sqlyog?

1011

What are the critical issues you have resolved in your company

2216

How to Set a root password if there is on root password.

1065

What is schema in mysql?

882

How to concatenate two character strings?

1009

What do you understand by mysql terminal?

1028

How does php communicate with mysql?

881

How to use in conditions?

983