Solved programming problem

For each job_id and each department, show the total no of employees in that group from the employees table

Source code

SELECT JOB_ID, DEPARTMENT_ID, COUNT(*) AS "No of Employe"

FROM employees

GROUP BY JOB_ID,DEPARTMENT_ID;
Join the discussion

Add your comment