number = 1
for iteration = 1
number = number + (iteration - 1)
for iteration > 1
1 到 5 的加總為：
1+2+3+4+5 = 15
遞迴範例－整數加總
在 SQL 中使用遞迴：Common Table Expression - CTE
WITH calculate_SumOfNumber AS
( -- Initial Query
SELECT 1 AS iteration, 1 AS SumOfNumber
UNION ALL
-- Recursive Part
SELECT iteration + 1, SumOfNumber + (iteration + 1)
FROM calculate_SumOfNumber
WHERE iteration < 6
)
SELECT SumOfNumber
FROM calculate_SumOfNumber
Preparing Video For Download...
