问当只选择部分数据时，如何计算正在运行的SQL语句总数？

EN

Declare @YourTable table (ID int,Amount int)
Insert Into @YourTable values (1,80),(2,11),(3,123),(4,47),(5,8),(6,500),(7,49),(8,27),(9,34),(10,56),(11,82),(12,17)

-- If 2012+  
Select *
      ,RunningTotal = sum(Amount) over (Order By ID)
 From @YourTable
 Where ID between 6 and 9

ID  Amount  RunningTotal
6   500     500
7   49      549
8   27      576
9   34      610

Select A.ID
      ,A.Amount
      ,RunningTotal = sum(B.Amount)
 From @YourTable A
 Join @YourTable B on (B.ID <=A.ID and B.ID between 6 and 9)
 Where A.ID between 6 and 9
 Group By A.ID,A.Amount
 Order By A.ID

Declare @YourTable table (ID int,Amount int)
Insert Into @YourTable values (1,80),(2,11),(3,123),(4,47),(5,8),(6,500),(7,49),(8,27),(9,34),(10,56),(11,82),(12,17)

select *, sum(amount) over (order by id rows unbounded preceding) as RunningTotal from @yourTable