# 계층형 쿼리

Hierarchical Query

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

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

SELECT n FROM nums;
```