建表及录入数据create table t (时间 datetime)
insert into t values ('2005-11-12 21:40:59.730')
insert into t values ('2005-11-17 13:13:57.640')
insert into t values ('2006-01-05 11:17:30.030')
insert into t values ('2006-02-27 20:17:45.077')
insert into t values ('2006-02-27 20:17:51.233')
insert into t values ('2006-02-28 18:17:24.450')
insert into t values ('2006-02-28 18:17:26.733')
insert into t values ('2006-02-28 18:17:29.560')
insert into t values ('2006-03-02 21:21:16.903')
运行如下代码select a.时间,datediff(s,a.时间,b.时间)
from
(select row_number() over (order by 时间) rn,时间 from t) a
left join
(select row_number() over (order by 时间) rn,时间 from t) b
on a.rn=b.rn-1
结果截图