delete from tablename where id not in (select max(id) from tablename group by col1,col2,...)
ORACLE删除重复记录
最新推荐文章于 2024-07-23 17:52:34 发布
delete from tablename where id not in (select max(id) from tablename group by col1,col2,...)