在ORACLE8i 的在线文档里有这么一个例子:SELECT ENAME, SAL, STDDEV(SAL) OVER (ORDER BY HIREDATE)
FROM EMP
WHERE DEPTNO=30;
ENAMESALSTDDEV(SAL
---------- ---------- ----------
ALLEN
1600
0
WARD
1250 247.487373
BLAKE
2850 841.130192
TURNER 1500 715.308791
MARTIN 1250 666.520817
JAMES
950 668.331255
我把它COPY到SQL*PLUS中运行时却报错:
SELECT ENAME, SAL, STDDEV(SAL) OVER
*
ERROR at line 1:
ORA-00937: not a single-group group function
请问这是为什么?