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

Explain what role entity and relationship play in an ER diagram.

1034

Which sql server is best?

963

What is xdr?

941

Explain the difference between cross join and full outer join?

938

How retrieve field names from the table in SQL through JAVA code?

1852

Explain the properties of subqueries in sql server?

1034

How to check status of stored procedure in sql server?

930

Can select statements be used on views in ms sql server?

1022

User wants only to display only pdf as export option in report manager. How to achieve this?

253

What is difference between rownum and rowid?

864

What is indexing explain it with an example?

958

Explain how dts is used to extract, transform and consolidate data?

963

Is it possible to update the views? If yes, how, if not, why?

983

Explain important index characteristics?

997

What do you mean by cardinality?

863