Neoview SQL Reference Manual (R2.5)
Manuals
Brands
HP Manuals
Software
HP Neoview Release 2.5 Software
501
502
503
504
505
506
507
508
509
510
SELECT deptnum, empnum, SUM (salary)
OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
FROM persnl.employee;
506
OLAP Functions
1
...
...
504
505
506
507
508
...
...
552