要实现您的要求，请尝试以下操作（从OP编辑后进行更新）：
SELECt A.requestid, A.starttime, (B.starttime - A.starttime) AS timedifferenceFROM MyTable A INNER JOIN MyTable B ON B.requestid = (A.requestid + 1)ORDER BY A.requestid ASC
如果
requestid不是连续的，则可以使用
SELECt A.requestid, A.starttime, (B.starttime - A.starttime) AS timedifferenceFROM MyTable A CROSS JOIN MyTable BWHERe B.requestid IN (SELECt MIN (C.requestid) FROM MyTable C WHERe C.requestid > A.requestid)ORDER BY A.requestid ASC
