Saturday 18 June 2011

How to remove duplicates in the table ?

Delete from EMP where rowid not in (select max (rowid) from EMP group by empno);

No comments:

Post a Comment