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

7 Answers
12093 Views
TCS, Thomson Reuters, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the index requirement in SQL Azure?

What options are available to audit login activity? : sql server security

1092

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

978

What are the extra roles available in msdb? : sql server security

1076

What is trigger explain with program?

931

How to find the list of fixed hard drive and free space on server?

1096

What is a transaction and why is it important?

999

How to call a function from a stored procedure in SQL Server ?

952

What is the library index called?

998

Is it possible to call a stored procedure within a stored procedure?

914

Explain optimistic and pessimistic concurrency?

927

How do I install only the client tools of sql server 2000?

992

What is the difference between web edition and business edition?

111

What is the difference between push and pull subscription? : sql server replication

1149

Can you explain about buffer cash and log cache in sql server?

905