SQL计算上下两行某列的差

fteair · 发表于 2020-3-20 15:14:23

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

fteair · 发表于 2020-3-23 17:45:34

fteair · 发表于 2020-3-23 17:46:38

fteair · 发表于 2020-3-23 17:47:51

fteair · 发表于 2020-3-23 17:48:24

		自动登录	找回密码
密码			立即注册

[分享] SQL计算上下两行某列的差