如何选出指定时间段内入库的商品数？谢谢

[mathnokia]

表的主键为(ID,Time)
ID是指商品编号； Time是指商品进入仓库的时间;
ID Time
------------------
086 2005.3.5 19:30:10
086 2005.3.5 21:00:20
073 2005.3.7 10:03:15
086 2005.3.9 08:12:20
073 2005.3.9 09:10:10
...
同一种类型的商品有多件，在不同的时间进入仓库，已知入库的时间是唯一的
如何求出在两天（或其他指定时间段）内入库数目超过 3件 (或其他数) 的商品的ID

谢谢

[lsqkeke]

select ID from tb
where datediff(dd,[Time],getdate())=2
group by ID
having count(*)>3

[子陌红尘]

select
a.ID
from
t a,t b
where
a.ID=b.ID and datediff(dd,a.Time,b.Time) between 0 and 1
group by
a.ID
having count(*)>3

[lsqkeke]

select ID from tb
where datediff(dd,[Time],getdate()) between 0 and 1
group by ID
having count(*)>3