id title
1 张三
2 李四
3 王思
4 甜甜
5 陈武
6 李四
7 甜甜
比如，我想删除 李四 甜甜 这种重复的title， 最好删除id考前的。
mysql语句怎么写
要从百万数据中删除上千条重复数据
重复数据要保留一条吗？
要的话如下：
delete from table where id not in (select max(id) from table group by title)
最好先备份下表数据再删除
delete from people
where title in (select title from people group by title having count(title) > 1)
and id not in (select min(id) from people group by title having count(title )>1)