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

What is sqlservr.exe - process - sql server (sqlex?press)?

1104

How to execute stored procedure and set temp table in sql server?

1034

When would you prefer to have a minimum number of indexes?

896

What is difference between inner join and full join?

1058

What is collation sensitivity?

1054

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

988

Explain data warehousing in sql server?

1039

What is an sql server agent?

1056

What gets stored inside msdb database?

1243

How do I setup a local sql server database?

997

How to delete database objects with "drop" statements in ms sql server?

1080

How would you choose between a clustered and a non-clustered index?

965

What is difference between foreign key and unique key?

1003

What are different types of statements that are supported by sql?

1036

What does it mean to be in union?

931