数据库中删除时间相同的记录？

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)