删除重复记录

 

delete from t1 where rowid not in (select max(rowid) from t1 group by empno);