id date bb
1 2008-12-31 3
2 2009-01-01 4
3 2009-01-01 4
主键是id
解决方法:
delete from 表名 where id in (select min(id),date from 表名
group by date having count(date)>1)
这是删除一条 2 3 id的时间相同 删除 2的了
如果你想全删除
delete from 表名 where date in (select date from 表名
group by date having count(date)>1)
如果你想删除第4个
delete from 表名 where id in (select max(id),date from 表名
group by date having count(date)>1)