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
Asked
Active
Viewed 23 times
0
Barbaros Özhan
- 59,113
- 10
- 31
- 55
cactus8888
- 16
- 2
-
Barbaros Özhan Can you please explain or share the query , thanks in advance. – cactus8888 Oct 15 '22 at 11:05
-
Hi . This is a very famous and common error in Oracle's SQL. I've just added more duplicate questions already answered each will explain what you need. Farewell. – Barbaros Özhan Oct 15 '22 at 11:11