Eliminating duplicate records in data cleansing
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