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

Can sql servers link to other servers like oracle?

902

What are the source of constraints?

998

Can we shrink data file in sql server?

1114

what is the difference between openrowset and openquery?

1181

Why and when do stored procedure recompile?

1044

What is the primary use of the model database?

1141

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8218

Where can you add custom error messages to sql server?

1193

What are wait types?

1227

What is normalization and what are the advantages of it?

1044

How to connect php with different port numbers?

1163

How can you append an identity column to a temporary table?

1056

What is self contained sub query?

1133

what is spatial nonclustered index

1050

Explain system functions or built-in functions? What are different types of system functions?

1055