Re: Duplicate Table Entries

something like

select *
from (
  select *,

      row_number() over ( partition by col1, col2, col3, col4 order by <whatever> ) as r   from my_table
)
where r > 1

show the rows that have a duplicated based on col1,2,3,4

htht
connor

• Lex de Haan <lex.de.haan_at_naturaljoin.nl> 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 :-)
  >
  > cheers,
  > Lex.
  >
  > > 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.
  > >
  > > Bill
  > >
  > > William Gaston
  > > Systems Designer / Information Technology
  > > USG Corporation
  > > Chicago, Il 60606
  > > (312) 606-3851
  > > wgaston_at_usg.com
  > >
  > > --
  > > http://www.freelists.org/webpage/oracle-l
  > >
  >
  >
  > --
  > http://www.freelists.org/webpage/oracle-l
  >
  

Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

"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

--
http://www.freelists.org/webpage/oracle-l