Neoview SQL Reference Manual (R2.4 SP2)

SELECT deptnum, empnum, AVG(SALARY)
OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
FROM persnl.employee;
482 OLAP Functions