계층형 쿼리

Hierarchical Query

• https://m.blog.naver.com/wiseyoun07/221135850258

snippet.sql

WITH RECURSIVE nums (n) AS (
    SELECT 1
  UNION ALL
    SELECT n+1 FROM nums WHERE n+1 <= 10
)
 
SELECT n FROM nums;