Oracle急问# Database - 数据库
e*o
1 楼
SELECT EMP.ENAME,EMP.DEPTNO,DEPT.DNAME FROM EMP,DEPT WHERE
EMP.DEPTNO=DEPT.DEPTNO GROUP BY EMP.DEPTNO ORDER BY EMP.ENAME
*
ERROR at line 1:
ORA-00979: not a GROUP BY expression
EMP.DEPTNO=DEPT.DEPTNO GROUP BY EMP.DEPTNO ORDER BY EMP.ENAME
*
ERROR at line 1:
ORA-00979: not a GROUP BY expression