DELETE FROM MyTable WHERE ID IN ( SELECT MAX(ID) FROM MyTable GROUP B

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

Question Posted / lince

7 Answers
12145 Views
TCS, Thomson Reuters, I also Faced
E-Mail Answers

Answer Posted / lince

DELETE
FROM MyTable
WHERE ID IN
(
SELECT MAX(ID)
FROM MyTable
GROUP BY DuplicateColumn1 HAVING COUNT(ID)>1
)

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What causes index fragmentation?

951

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

942

What the class forname () does?

987

Can sub report data source be different from that of the parent report?

137

Name few of the dcl commands in sql?

956

Can a database be shrunk to 0 bytes, if not, why?

1048

What is the boxing and unboxing concept in .net?

876

What is mapping schema?

991

What happens to a statement batch if there is a compilation error?

910

Is it possible for a stored procedure to call itself or recursive stored procedure?

904

Explain what is meant by replication of database?

969

How to recreate an existing index in ms sql server?

1002

Explain full-text query in sql server?

955

How can I add Reporting Services reports to my application?

127

What are the new features are introduced in sql server 2012 reporting services?

145