Hi gurus,
How can i compare the rows with in same table and see if they are same. I want to compare the column idcd with in each row of the same table and see if it is repeated, if yes then display another column exist , not exist values.
out put should be something like this.
with qry as
(
select 123 idord , 15130 idcd ,1 stord from dual union all
select 234,103421, 2 from dual union all
select 345, 15130, 3 from dual union all
select 342, 103421,1 from dual
) SELECT * FROM qry