10 Oct
2006
10 Oct
'06
6:27 p.m.
Hello again kind people.
This is an sql self join on TableA which contains a serial primary key
column called 'seq'. The select is limited to less than 400 rows of
output by 'a1.seq<=400'.
sql->select a1.*, sum(a2.num)/17 from TableA a1, TableA a2 where
a1.seq<=400 and a1.seq>=17
and a1.seq