delete from tbl_test where ID in (select ID from tbl

Write a query to delete duplicate records in SQL SERVER

Question Posted / prakash patel

Answer Posted / prakash patel

delete from tbl_test where ID in
(select ID from tbl_test group by ID having count(ID) > 1)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why we need sql server?

1013

What is the difference between writing data to mirrored drives versus raid5 drives

988

How to recompile stored procedure at run time?

1116

Explain transaction isolation levels in sql server?

1182

If we delete pack Spec what will be the status of pack Body ?

1522

What are the types of indexes?

1132

What methods do you follow to protect from sql injection attack?

1075

How to scale out a federation by Sql statement?

118

How do I perform an unattended install of sql server 2000?

1138

How to return the second 5 rows in ms sql server?

1106

how would you improve etl (extract, transform, load) throughput?

1074

What is cte (common table expression)?

1085

What is cursor in ms sql server?

1201

How to delete all rows with truncate table statement in ms sql server?

1045

What is meant by datasource?

983