Re: newbie question, unique index || double entries

This ought to help:

select distinct(column_name) from table_name where rowid not in
(select max(rowid) from table_name
group by column_name);

table_name = the name of the table
column_name = the name of the column for wich duplicates are being searched

The output for the above will be all the DATA VALUES from column column_name having more than one entry.

Regards,

Grant Received on Thu Aug 26 1993 - 14:22:27 CEST