27,579
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([Effective_Date] DATETIME,[X_value] decimal(18,8))
Insert #T
select N'2019-08-27 01:00:20.000',1.00 union all
select N'2019-08-29 09:18:44.000',2.50 union all
select N'2019-08-29 09:20:33.000',3.00
Go
--测试数据结束
;WITH cte AS (
Select *,ROW_NUMBER()OVER(ORDER BY Effective_Date) rn from #T
)
SELECT a.*,a.X_value-ISNULL(b.X_value,0) AS RM_value FROM cte a LEFT JOIN cte b ON a.rn=b.rn+1