DELETE
FROM team
WHERE id NOT IN
(SELECT a.id
FROM
(SELECT MIN(id) AS id
FROM team
GROUP BY name ) a)
Mysql:从team表中执行一个删除语句,当name 列上有相同时,只保留 ID 这列上值小的
最新推荐文章于 2022-05-10 20:16:21 发布
DELETE
FROM team
WHERE id NOT IN
(SELECT a.id
FROM
(SELECT MIN(id) AS id
FROM team
GROUP BY name ) a)