SQL计算上下两行某列的差

SELECT * FROM #TempHuDong

 

SELECT * FROM #TempHuDong
SELECT TOP 1 ABS(a.num -b.num) '差'
FROM (select row_number()over(order by getdate()) as id,* from #TempHuDong) as a
LEFT JOIN (select row_number()over(order by getdate()) as id,* from #TempHuDong) as b
ON a.id = b.id - 1

 

posted @ 2018-04-20 08:54  花街や小洪  阅读(1724)  评论(0编辑  收藏  举报