Eliminating duplicate records in data cleansing I have a database full of records of people with simple information like first name, last name, email, location, ... . I need to eliminate the duplicate records. As I've search the process is called "duplicate elimination in Data Cleansing". Does anyone know a good open source tool to do that?
Using T-SQL &amp; PL/SQL, you can use ROW_NUMBER() OVER (PARTITION BY) to find and delete duplicate records in a Table.

Refer to some best examples Removing Duplicates from a Table in SQL Server 
and How can I remove duplicate rows? as well as Oracle 'Partition By' and 'Row_Number' keyword