Neoview SQL Reference Manual (R2.3)

window-frame-clause
specifies the window within the partition over which the VARIANCE is computed.
Examples of VARIANCE
• Return the variance of the SALARY column::
SELECT empnum, VARIANCE (salary)
OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
FROM persnl.employee;
• Return the variance of the SALARY column within each department:
SELECT deptnum, empnum, VARIANCE (salary)
OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
FROM persnl.employee;
456 OLAP Functions