select b.id,b.username
from test b
where b.id not in (select max(t.id) as id
from test t
having count(t.username) > 1
group by t.username)
and b.username in (select t.username
from test t
having count(t.username) > 1
group by t.username);
删除重复数据保留id最大那条
最新推荐文章于 2024-05-21 15:40:44 发布