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

Explain throw statement in sql server 2008?

982

What is an execution plan? When would you use it?

970

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

956

When I run the sql server 2000 setup, it just hangs. What do I do?

1072

How to use old values to define new values in update statements in ms sql server?

1258

Do you know what is a linked server in sql server?

1018

How will you make an attribute not process? : sql server analysis services, ssas

1076

What is a transact-sql statement batch in ms sql server?

1010

What is ms sql server triggers?

1001

What are the requirements on sql server network connections?

966

What is query parameter in ssrs?

160

How to optimize stored procedures in sql server?

1175

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1001

What do you mean by tablesample?

1070

What is blocking?

1051