sql语句求出间隔时间为1秒的数据

[CUMBER]

time name
2009-11-17 17:02:33 tom
2009-11-17 17:02:34 tom
2009-11-17 17:02:37 lucy

---想要结果：tom在间隔1秒的时间范围内出现的条目为2。

[ACMAIN_CHM]

select a.name,count(*)
from yourTable a inner join yourTable b on a.name=b.name and a.time>b.time
where a.time-b.time<1/60/60/24
group by a.name

[CUMBER]

time name
2009-11-17 17:02:33 tom
2009-11-17 17:02:34 tom
2009-11-17 17:02:37 lucy
2009-11-17 17:02:38 lucy

[CUMBER]

始终查处到一条呢？
应该为2条吧

[ACMAIN_CHM]

select a.name,count(*)+1
from t_CUMBER a inner join t_CUMBER b on a.name=b.name and a.time>b.time
where datediff('s',a.time,b.time)<=1
group by a.name

[CUMBER]

谢谢
学习....