;WITH T AS (SELECT ROW_NUMBER() OVER(ORDER BY [SalesDate] DESC) AS ROWNUM
,Amount
,[SalesDate]
FROM TempTable
WHERE UserID=N'AA')
SELECT A.ROWNUM,A.Amount,A.[SalesDate],
(SELECT SUM(B.Amount) FROM T B WHERE B.ROWNUM>=A.ROWNUM) TotalAmount
FROM T A
,Amount
,[SalesDate]
FROM TempTable
WHERE UserID=N'AA')
SELECT A.ROWNUM,A.Amount,A.[SalesDate],
(SELECT SUM(B.Amount) FROM T B WHERE B.ROWNUM>=A.ROWNUM) TotalAmount
FROM T A
扫一扫
858
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
