davidcook: (circuit)
posted by [personal profile] davidcook at 11:33am on 07/06/2007
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


Answer here ... )
Mood:: 'geeky' geeky

November

SunMonTueWedThuFriSat
          1 2
 
3
 
4
 
5
 
6
 
7
 
8
 
9
 
10
 
11
 
12
 
13
 
14
 
15
 
16
 
17
 
18
 
19
 
20
 
21
 
22
 
23
 
24
 
25
 
26
 
27
 
28
 
29
 
30