DELETE FROM admin
WHERE id in(SELECT max(id) AS min_id FROM admin where ext like '32%' GROUP BY num having count(*)>1)
pgsql删除重复的数据保留一条
于 2023-11-06 21:01:04 首次发布
DELETE FROM admin
WHERE id in(SELECT max(id) AS min_id FROM admin where ext like '32%' GROUP BY num having count(*)>1)