Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get a count of number of employees per department

User_FZOVQMar 20 2022 — edited Mar 20 2022

Hi, I did an inner join between EMPLOYEES table and DEPARTMENT table. Then I proceeded to count the number of employees per department. However, it return not as a sum result. I tried to did SUM(COUNT(E.DEPARTMENT_ID)) and it got an error. I wonder if anyone has any advice? Ultimately, I would only want to have a department that has only more than 4 employees. Thanks

This post has been answered by Solomon Yakobson on Mar 20 2022

Jump to Answer

Added on Mar 20 2022

#general-database-discussions, #sqldeveloper

3 comments

5,220 views