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, MIN(salary)
OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
FROM persnl.employee;
MIN Window
Function
501
1
...
...
499
500
501
502
503
...
...
552