Neoview SQL Reference Manual (R2.5)

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