建议先在这张表上加一个自增列,这样删除的时候比较方便 。是A 和 B 两列合并后,重复的? 还是 A 、 B 各重复的? 前者:delete mytable x where id > (select MAX(id) from mytable where x.name + x.name2 = name + name2) 后者:delete mytable x where id > (select MAX(id) from mytable where x.name = name and x.name2 = name2)
delete a from 我现在又一个表 a,( select a,b,min(id) as id from 我现在又一个表 group by a,b ) b where a.a=b.a and a.b=b.b and a.id!=b.id
前者:delete mytable x
where id > (select MAX(id) from mytable where x.name + x.name2 = name + name2)
后者:delete mytable x
where id > (select MAX(id) from mytable where x.name = name and x.name2 = name2)
select a,b,min(id) as id
from 我现在又一个表
group by a,b
) b
where a.a=b.a and a.b=b.b and a.id!=b.id