Write a query to display the number of people with the same job
Write a query to display the number of people with the same job
Originally Posted by pappujk
Here is the query
SQL> SELECT JOB,COUNT(*) NOOFEMP
2 FROM EMP
3 GROUP BY JOB;
JOB NOOFEMP
--------- ---------
ANALYST 2
CLERK 4
MANAGER 3
PRESIDENT 1
SALESMAN 4
Last edited by krishnaindia2007; 05-30-2008 at 10:40 PM.
Test for whom?
select ename from employee group by jobname;
select count(empno),job from emp group by job;
Posting Permissions
Reply With Quote