delete from tp_wechat where id not in (
select t.max_id from
(select max(id) as max_id from tp_wechat group by mobile) as t
);
MySQL 删除重复记录sql语句
最新推荐文章于 2024-07-27 19:11:07 发布
delete from tp_wechat where id not in (
select t.max_id from
(select max(id) as max_id from tp_wechat group by mobile) as t
);