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

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1075

How to find the source of a table in sql server?

997

Differentiate between SQL and ORACLE joins and write their syntax.

1033

What is self contained multi valued query?

1014

Which are the important points to note when multilanguage data is stored in a table?

996

what are the new features introduced in sql server 2000? : Sql server database administration

915

Name and describe few console utilities for ssrs?

284

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1037

What do you understand by SQL*Net?

1030

Define msdb database?

1016

what is bit datatype? : Sql server database administration

916

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

972

What is the difference between truncate and delete commands?

1066

How to use the inserted and deleted pseudo tables?

961

which table keeps the locking information? : Sql server administration

1090