can you please provide Oracle version and sample data either in the form of tab/e / insert statements or with a, 'with', select clause.
Also please provided expected output
Hi i got the logic
from PS_DUP_INV_CMP A
where exists (select null
where VOUCHER_ID = A.VOUCHER_ID2
and VOUCHER_ID2 = A.VOUCHER_ID
and VOUCHER_ID2 > VOUCHER_ID);
this worked and got me the desired results.