WITH dual AS
(
SELECT 1 AccountID, 1 LEVEL
UNION ALL SELECT 2,2
UNION ALL SELECT 3,3
UNION ALL SELECT 4,4
UNION ALL SELECT 5,5
UNION ALL SELECT 6,6
UNION ALL SELECT 7,7
UNION ALL SELECT 8,8
UNION ALL SELECT 9,9
)
SELECT a.AccountID, SUM(a.LEVEL) over (order by a.AccountID )as C2
From dual a
WHERE a.LEVEL < 10
group by a.AccountID ,a.Level
누적합이 왜 안구해질까요 order by 를 인식을 못하네요 ㅠㅠ
SUM(a.LEVEL) over (order by a.AccountID ) <= 이런 구문도 있나여????
WITH dual AS
(
SELECT 1 AccountID, 1 LEVEL
UNION ALL SELECT 2,2
UNION ALL SELECT 3,3
UNION ALL SELECT 4,4
UNION ALL SELECT 5,5
UNION ALL SELECT 6,6
UNION ALL SELECT 7,7
UNION ALL SELECT 8,8
UNION ALL SELECT 9,9
)
SELECT a.AccountID, ( select Sum(LEVEL) from dual where AccountID <= a.AccountID )as C2
From dual a
WHERE a.LEVEL < 10
group by a.AccountID ,a.Level