Calculate Time Difference Between Two Rows
WITH rows AS ( SELECT *, ROW_NUMBER() OVER (ORDER BY DataDate) AS rn FROM mytable ) SELECT DATEDIFF(second, mc.DataDate, mp.DataDate) FROM rows mc JOIN rows mp ON mc.rn = mp.rn – 1 In SQL Server 2012+: SELECT DATEDIFF(second, pDataDate, dataDate) FROM ( SELECT *, LAG(dataDate) OVER (ORDER BY dataDate) pDataDate FROM rows ) q WHERE … Read more