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

What is bulkcopy in sql?

903

How do I view views in sql server?

941

What the different components in replication and what is their use?

915

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

934

What is the difference between grant and with grant while giving permissions to the user?

900

What do you know about normalization and de- normalization?

871

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

904

Explain forward - only cursors?

986

How you can get a list of all the table constraints in a database?

909

What does Master database contains?

1085

What is the xml datatype?

993

How can we remove orphan records from a table?

933

can a database be shrunk with users active? : Sql server administration

953

What command must you use to include the not null constraint after a table has already been created?

1053

Why use “in” clause in sql server?

996