By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH RECURSIVE cte (n) AS
(
SELECT 1
UNION ALL
SELECT (n + 1) FROM cte WHERE n < 10
)
SELECT POW(n,2) FROM cte;
| POW(n,2) |
|---|
| 1 |
| 4 |
| 9 |
| 16 |
| 25 |
| 36 |
| 49 |
| 64 |
| 81 |
| 100 |
| POW(n,2) |
|---|
| 1 |
| 4 |
| 9 |
| 16 |
| 25 |
| 36 |
| 49 |
| 64 |
| 81 |
| 100 |