계층형 쿼리
Hierarchical Query
- snippet.sql
WITH RECURSIVE nums (n) AS ( SELECT 1 UNION ALL SELECT n+1 FROM nums WHERE n+1 <= 10 ) SELECT n FROM nums;
관련 문서
Plugin Backlinks: 아무 것도 없습니다.
open:계층형-쿼리
Hierarchical Query
WITH RECURSIVE nums (n) AS ( SELECT 1 UNION ALL SELECT n+1 FROM nums WHERE n+1 <= 10 ) SELECT n FROM nums;