怎样写一条SQL统计连续两条记录的值相加？

[lsp69]

有以下表:

ID 入 出 余额
1 0 1 -1
2 0 2 -3
3 2 0 -1
4 0 4 -5
5 8 0 3

即根据ID值的大小，后一条记录的余额等于前一条记录的(入-出)

[w87875251l]

逻辑上不太懂啊

[James__z]

这个易接受！哈哈。。。。。

[还在加载中灬]

SELECT T1.ID,T1.入,T1.出,SUM(T2.入-T2.出)
FROM TB T1
	JOIN TB T2 ON T1.ID>=T2.ID
GROUP BY T1.ID,T1.入,T1.出

[向东流]

select *, (select sum(入 -出)  from tb b where a.id>=b.id) from tb a

[mugua604]

CREATE TABLE #TABLENAME(ID INT,INQTY INT,OUTQTY INT)

INSERT INTO #TABLENAME
SELECT 1,0,1
UNION ALL
SELECT 2,0,2
UNION ALL
SELECT 3,2,0
UNION ALL
SELECT 4,0,4
UNION ALL
SELECT 5,8,0


SELECT *,(SELECT SUM(INQTY-OUTQTY) FROM #TABLENAME WHERE ID<=T0.ID ) FROM #TABLENAME T0

DROP TABLE #TABLENAME

(5 行受影响)
ID          INQTY       OUTQTY      
----------- ----------- ----------- -----------
1           0           1           -1
2           0           2           -3
3           2           0           -1
4           0           4           -5
5           8           0           3

(5 行受影响)