Re: Duplicate Table Entries
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: wgaston@xxxxxxx
- Date: Fri, 15 Apr 2005 21:43:03 +0200 (CEST)
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@xxxxxxx
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts: