Re: HELP! Oracle script for identify identical records

ko wrote:

> I have a table which consists of n columns. I need to list those
> identical records. The coditions for identical records are column A
> and column B of those records must contain the same value and column
> C must contain 'Y'. Can someone enlighten me how to write an Oracle
> SQL script to accomplish this?
>
> Many thanks for your help.

select *
from table_name t1, table_name t2
where t1.A = t2.A

and t1.B = t2.B
and t1.C = 'Y'
and t2.C = 'Y'
and t1.rowid <> t2.rowid

--