delete from zhszty_ebook where id not in( select * from (select max(id) from zhszty_ebook group by url ) as tmp);------------mysql有个特性,对于表进行修改,删除操作,子查询不能和外层的查询的表一样,所以在加个select就可以了。其他数据库按照楼上的那个是没问题的
热心网友时间:2022-04-08 07:47
delete from (select a.*,row_number() over(partition by a.姓名,a.项目,a.时间,a.价格 order by a.序号) rd from table_name a) where rd>'1'; commit;