Neoview SQL Reference Manual (R2.4 SP2)
Manuals
Brands
HP Manuals
Software
HP Neoview Release 2.4 Software
491
492
493
494
495
496
497
498
499
500
SELECT deptnum, empnum, SUM (salary)
OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
FROM persnl.employee;
494
OLAP Functions
1
...
...
492
493
494
495
496
...
...
538