Re: finding redundant data in a table

On Wed, 02 May 2001 14:32:36 GMT, goldensurfer_at_gmx.de (Ralf Zwanziger) wrote:

>How can I find out records in a table in which all fields contain
>the same data, except the ID column (which is my primary key)?
>
>Thanks in advance,
>Ralf

select * from foo x
where exists
(select 'x'
 from foo y
 where y.id <> x.id
 and y.a = x.a
 and y.b = x.b
....
)

Hth

Sybrand Bakker, Oracle DBA Received on Wed May 02 2001 - 17:17:30 CDT