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