June 7th, 2007

circuit

SQL geekery ...

So, what does the following bit of SQL do ?

with temp (num)
as (select 5 from sysibm.sysdummy1
union all
select num + 1
from temp
where num < 37)
select * from temp


Collapse )
  • Current Mood
    geeky geeky