对于表如下: 表名 agv_conflict;字段如下:
id integer;
name string;
aspirit integer;
bspirit integer;
如何删除 aspirit和bspirit完全相同的行,并且保留一个行?
答案如下:
DELETE FROM agv_conflict
WHERE id NOT IN
(
SELECT MIN(id)
FROM agv_conflict
GROUP BY aspirit,bspirit
)