求SQL语句，查询出在某个时间段内ID出现超过3次的ID。

[julong88]

求SQL语句，查询出在某个时间段内ID出现超过3次的ID

[發糞塗牆]

select id
from tb
where 时间列 between 开始时间 and 结束时间
group by id
having count(1)>3

[---涛声依旧---]

select id from tbl1 where time1 between '2014-01-01' and '2014-03-05' group by id having count(*)>3

[xxfvba]

select id,count(*) from T where Date between '2014-1-1' and '2014-2-1' group by id having count(*)>3 这样？不是吧

[xxfvba]

靠，我还以为我是第一个呢