OracleApps
Deleting of duplicate records based on latest Timestamp
delete from emp t1
where hiredate != (select max(t2.hiredate)
from emp t2
where t2.eno = t1.eno)
and eno = 1
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment