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

Delete duplicate records from the table?(Table must have
unique id)

Question Posted / kk

Answer Posted / kk

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

Is This Answer Correct ?

7 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is an sql server agent?

994

Explain log shipping and mention its advantages.

988

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1853

How can I tell if sql server is 32 or 64 bit?

901

What is 2nf normalization form?

1048

How do I connect to sql server database?

950

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

929

Create and insert into temp table in sql server?

976

when would you go for denormalization? : Sql server database administration

809

Can we hide the definition of a stored procedure from a use?

1133

How do I edit a procedure in sql server?

897

What’s the use of custom fields in report?

888

can an order by clause be used in a creation of a view?

1099

How to rebuild master databse?

1028

Explain transaction server isolation?

979