delete id from table where id in(select id from table having count(id)>1

Delete duplicate records from the table?(Table must have
unique id)

Question Posted / naren

Answer Posted / naren

delete id from table where id in(select id from table having count(id)>1)

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Does order by actually change the order of the data in the tables or does it just change the output?

1146

How to declare and use cursor variables?

1171

How to create nested stored procedure?

1019

What are the properties of sub-query?

1074

what is the difference between Delete and Truncate command in SQL

1147

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

988

What part does database design plays a role in performance of an sql server-based application?

983

What is raiseerror? What is raiseerror?

1141

Can you pass expressions to stored procedure parameters?

1037

What is implicit cursors?

1085

Does server sql treat char as a variable-length or fixed-length column?

1034

How to find the version of sql server? : sql server database administration

1111

What different steps will a sql server developer take to secure sql server?

995

What is the process of indexing?

1009

What are indexers?

1086