只需一条简单sql语句
DELETE FROM ceshi WHERE id NOT IN (SELECT id from ( SELECT min(id) AS id FROM ceshi GROUP BY `name`,class)a)
只需一条简单sql语句
DELETE FROM ceshi WHERE id NOT IN (SELECT id from ( SELECT min(id) AS id FROM ceshi GROUP BY `name`,class)a)
本文基于《署名-非商业性使用-相同方式共享 4.0 国际 (CC BY-NC-SA 4.0)》许可协议授权
文章链接:https://blog.aaayun.cc/archives/365.html (转载时请注明本文出处及文章链接)
如果觉得我的文章对你有用,请随意赞赏
0
条评论