[SQL] 1부터 N까지 나오게

SET @N = 5;

WITH RECURSIVE rgen(n) AS ( 
    SELECT 1 
    UNION ALL 
    SELECT n + 1 
    FROM rgen 
    WHERE n < @N
) 
SELECT n 
FROM rgen;

결과

n

1

2

3

4

5