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

How to divide query output into multiple groups with the group by clause in ms sql server?

958

What are tables in sql server?

961

Explain time data type in sal server 2008?

869

What are the different sql server versions?

930

What is self contained scalar sub query?

924

What is the cartesian product of table?

929

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

952

How to return the top 5 rows from a select query in ms sql server?

1072

What does it mean if @@cursor_row returns a negative number?

940

What are the transaction properties?

963

How to delete duplicate rows?

928

what is denormalization? : Sql server database administration

876

What is dbcc? Give few examples.

950

Tell me when is the update_statistics command used?

1016

What happens if an integer is too big for int date type?

919