OS:WIN7
DB:SQL2008R2select '1' as xh,200 as rsl,0 as csl into #s
union
select '2' as xh,0 as rsl,20 as csl
union
select '3' as xh,0 as rsl,90 as csl
union
select '4' as xh,10 as rsl,0 as csl
union
select '5' as xh,30 as rsl,0 as csl--希望结果
xh,rksl,csl,jcsl
1 200 0 200
2 0 20 180
3 0 90 90
4 10 0 80
5 30 0 110
DB:SQL2008R2select '1' as xh,200 as rsl,0 as csl into #s
union
select '2' as xh,0 as rsl,20 as csl
union
select '3' as xh,0 as rsl,90 as csl
union
select '4' as xh,10 as rsl,0 as csl
union
select '5' as xh,30 as rsl,0 as csl--希望结果
xh,rksl,csl,jcsl
1 200 0 200
2 0 20 180
3 0 90 90
4 10 0 80
5 30 0 110
SELECT *,jcsl=(SELECT SUM(rsl-csl) FROM #s A WHERE A.xh <=#s.xh )
FROM #s/*
xh rsl csl jcsl
1 200 0 200
2 0 20 180
3 0 90 90
4 10 0 100
5 30 0 130*/