7 Years
Discussion Span
Last Post by willopt_ric

Hi Raman,

Which database do you want to delete duplicate records?

I may need to write an article for each database.

For SQL Server, you ca find solutions in the following links.

How to remove duplicate rows from a table in SQL Server
How to Identify and Delete Duplicate SQL Server Records
How to Delete SQL Server Database Duplicate Rows from a Table Using a Specified Column List and No Temp Tables
How to delete duplicate records in sqlserver

Edited by Ramesh S: n/a


Does anyone knows about how we can delete duplicate fields in the database?
Thank u in advance.......

delete from table
where rowid not in(select min(rowid) from table_name group by C1,c2,c3....(all column names));
Like this ...u can write in oracle....like to know from u for further clarifcations.....

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.