删除重复记录

 

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

posted @ 2014-11-30 11:16  智能先行者  阅读(131)  评论(0)  编辑  收藏  举报