SQL -如何计算大于1秒间隔的实例# ?

Question

我想计数">

我在

下面有这样的内容

<表类>账户#时间tbody><<tr>12345610:02:0112345610:02:0212345610:10:02

select   Account
,count(case when sec_diff > 1 then 1 end) as cnt
from      

(
select   *
,datediff(second, lag(time) over(partition by account order by time), time) as sec_diff
from     t
) t

group by Account

<表类>账户问tbody><<tr>1234561