再帰クエリ

• MySQL

(5.6)
対応していない

(8.0)
※ recursiveが必要

with recursive t1(col1) as(
select 1
union all
select col1+1
from t1
where col1+1 <= 100
)
select col1 from t1
;

• Oracle

(12cR1)

https://www.oracle.com/technetwork/jp/articles/otnj-sql-image7-1525406-ja.html

※ recursiveは不要

with t1(col1) as(
select 1 from dual
union all
select col1+1
from t1
where col1+1 <= 100
)
select col1 from t1
;

• PostgreSQL

(9.4)
※ recursiveが必要

with recursive t1(col1) as(
select 1
union all
select col1+1
from t1
where col1+1 <= 100
)
select col1 from t1
;

• SQL Server

(2014)

※ recursiveは不要

with t1(col1) as(
select 1
union all
select col1+1
from t1
where col1+1 <= 100
)
select col1 from t1
;