Find out Duplicate records.

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 627
select * from emp where rowid in(select min(rowid) from emp where employee_id in(select employee_id from emp group by employee_id having count(*)>1)group by employee_id)

Comments or Responses

Login to post response