Neoview SQL Reference Manual (R2.5)

SELECT deptnum, empnum, MAX(salary)
OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
FROM persnl.employee;
MAX Window Function 499