Delete from (select * from <TABLE_NAME> where rowid not in (select m

How To delete duplicate record from a particular table?

Question Posted / sudhagar

Answer Posted / sudhagar

Delete from (select * from <TABLE_NAME> where rowid not in
(select min(rowid) from <TABLE_NAME> group by c1,c2...))

Is This Answer Correct ?

3 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain Geometry datatype in sql server 2008 with example

966

What are binary string data types in ms sql server?

1275

How to create a user name in a database?

1043

List few advantages of stored procedure.

979

What is bookmark link in ssrs?

244

What is data compression? : sql server database administration

964

how to trace the traffic hitting a sql server? : Sql server database administration

1864

What is difference between global temporary tables and local temporary tables?

1227

What do you understand by the denormalisation?

949

What is the use of custom fields in report?

992

Is there any difference between the primary key and unique key?

997

explain extended properties

981

what are the different types of replication you can set up in sql server? : Sql server database administration

1018

What is code near application topology?

279

What is isolation levels?

1020