DELETE FROM MyTable WHERE ID NOT IN ( SELECT MAX(ID) FROM MyTable GRO

Write a query to delete duplicate records in SQL SERVER

Question Posted / anuj dhingra

Answer Posted / anuj dhingra

DELETE
FROM MyTable
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM MyTable
GROUP BY DuplicateColumn1, DuplicateColumn2,
DuplicateColumn2)

Is This Answer Correct ?

12 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Explain throw statement in sql server 2008?

1054

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1049

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

950

How does clustered and non clustered index work?

978

What is molap and its advantage? : sql server analysis services, ssas

1036

Explain syntax for dropping triggers?

967

How to get all stored procedures in sql server?

1059

How data can be copied from one table to another table?

1002

What is identity?

1080

What are the types of table?

1028

what's sql server? : Sql server database administration

1051

What is ms sql server index?

1149

What is the report builder?

143

What is a fan-out query in SQL Azure?

123

How to generate random numbers with the rand() function in ms sql server?

1223