Friday, 17 July 2015

How to get duplicate values from table ?

select * from emp where rowid not in (select min(rowid) from emp group by empno);
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...