RosettaCodeData/Task/Factorial/SQL/factorial.sql

7 lines
120 B
SQL

WITH RECURSIVE f(a, b) AS (
VALUES(1, 1)
UNION ALL
SELECT a * b, b + 1 FROM f WHERE b <= 9
)
SELECT MAX(a) FROM f