DB2 how to achieve output of digital 1~100

Want to realize the output of continuous numbers, how to use a SQL implementation?

Started by Rudolf at December 12, 2016 - 1:40 AM

with t(id) as
(
select 1 as id from sysibm.sysdummy1 a
union all
select id+1 as id from t,sysibm.sysdummy1 a where id<=100
)
select id from t

Posted by Tiffany at December 23, 2016 - 1:50 AM