cactus8888
cactus8888

Reputation: 16

sql oracle query group by issue

select e.EMPNO, e.EMPNAME ,e.DEPT_NO, d.DEPT_NAME
 FROM EMPLOYEE e , DEPARTMENT d
  WHERE e.DEPT_NO = d.DEPT_NO 
GROUP BY d.DEPT_NO;

ORA-00979: not a GROUP BY expression

Upvotes: 0

Views: 28

Answers (0)

Related Questions