RosettaCodeData/Task/String-append/DuckDB/string-append-1.duckdb

9 lines
146 B
Text
Raw Permalink Normal View History

2025-08-11 18:05:26 -07:00
with recursive t(i, s) as (
select 0, 'foo'
union all
select i+1, s || 'bar'
from t
where i < 1)
select last(s order by i) as s
from t;