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)

How to schedule PO workflow schedule process

create or replace PACKAGE APPS.XXXX_PO_WF_SCHEDULING_PKG IS    --|==========================================================================...