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

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

Please Help Members By Posting Answers For Below Questions

How to achieve Paging of records in SQL SERVER?

1089

How do you clear a log file?

1036

what is the primary use of the model database? : Sql server administration

1035

What is normalization? What number of normalization shapes are there?

1095

What are sql servers used for?

1035

What is a database in ms sql server?

1050

What is the filtered index?

1039

What is the chart in report?

158

What is Federation and Federation Member?

How to set database to be read_only in ms sql server?

995

What is the purpose of the master database?

1113

What kind of problems occurs if we do not implement proper locking strategy?

1395

What are the differences between stored procedure and the dynamic sql?

1075

how you can configure a running aggregate in SSRS?

188

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

936