Return to Snippet

Revision: 48784
at July 9, 2011 00:21 by xavsio4

Initial Code
select fields, fields, ROW_NUMBER OVER (PARTITION primary key(s) order by...) seq
FROM table WHERE condition

Initial URL

Initial Description
This sql statement enables to detect duplicates entries over a key and creates a seq column which says which one is the sequence of the duplicates. This way you can take only the seq = 1 and still be able to identify all duplicates

Initial Title
Strategy to identify duplicates in an ETL context (for example)

Initial Tags
sql, Oracle

Initial Language