察看每一个编号的纪录数
Select 编号 As ID,count(编号) As Cnt From tablename
Where time Between time1 And time2
Group By id
显示记录数大于3条以上的纪录编号
Select ID
From
(
Select 编号 As ID,count(编号) As Cnt From tablename
Where time Between time1 And time2
Group By id
) As t1
Where Cnt>3
显示记录数大于3条以上的纪录
Select *
From YourTableName As t2,
(
Select ID
From
(
Select 编号 As ID,count(编号) As Cnt From tablename
Where time Between time1 And time2
Group By id
) As t1
Where Cnt>3
) As t3
Where (t2.编号=t3.ID) And (time Between time1 And time2)
建议聚合结果表t1保存临时表。