|| at Apr 16, 2005 at 7:11 am
row_number() over ( partition by col1, col2, col3, col4 order by ) as r
where r > 1
show the rows that have a duplicated based on col1,2,3,4
Lex de Haan wrote:
are these "3 or 4 columns" always the same columns, for all rows, or do
you want to identify the rows that are "almost identical" in general?
in case you mean the former, that's relatively easy. the latter will take
some more intelligence :-)
Good Day All,
I have a table with more than 100 columns of data. In some cases,
several rows may have duplicate data except for 3 or 4 columns.
Is there an easy way to find those rows?
Thanks in advance for any assistance.
Systems Designer / Information Technology
Chicago, Il 60606
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Send instant messages to your online friends http://uk.messenger.yahoo.com