22,301
社区成员




;WITH CTE AS(
SELECT 'A1' AS Id,3 as Num,1 AS OrderIndex UNION ALL
SELECT 'A2' AS Id,2 as Num,2 AS OrderIndex UNION ALL
SELECT 'A3' AS Id,3 as Num,3 AS OrderIndex UNION ALL
SELECT 'B1' AS Id,1 as Num,4 AS OrderIndex UNION ALL
SELECT 'B2' AS Id,4 as Num,5 AS OrderIndex
)
SELECT A.Id,SUM(B.Num) AS NUM
FROM CTE a
JOIN CTE b ON b.Id<=a.Id
GROUP BY A.Id
select Id,SUM(Num) as Num
from tb t1
inner join tb t2
on t2.OrderIndex<=t1.OrderIndex
group by id
select Id,(select SUM(Num) from tb where OrderIndex<=t.OrderIndex) AS Num
from tb as t