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

Recommended Answers

All 2 Replies

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

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.....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.