oradev03

 Profile Answers by oradev03 

• Sep 17th, 2006

 

SELECT job,COUNT(*) As "No of employees"

FROM emp

GROUP BY job;

Dakshina Murthy

• Dec 22nd, 2006

 

SELECT job,COUNT(*)

FROM emp

GROUP BY job;

amikat

 Profile Answers by amikat 

• Jun 3rd, 2008

 

 select job, count(ename)
 from emp
 group by job;

sravee123

 Profile Answers by sravee123 

• Jun 4th, 2008

 

 SELECT job,COUNT(*)

FROM emp

GROUP BY job;

lanka_satya

 Profile Answers by lanka_satya 

• Sep 12th, 2008

 

select  count(name) from emp e where 1>(select count(*) from emp x where x.job=e.job)

POPAM143

 Profile Answers by POPAM143 

• Oct 29th, 2008

 

SELECT job, count(*) AS no.ofemployee FROM emp GROUP BY job;

sankar babu

 Profile Answers by sankar babu 

• May 25th, 2011

 

select job,count(*) no_of_employees

from emp

group by job;

machomanic

 Profile Answers by machomanic 

• May 26th, 2011

 

Hello,

This will give you the number of employees according to the job.

select count(*), job
from emp
group by job;

sandeshshinde000

 Profile Answers by sandeshshinde000 

• Jun 4th, 2011

 

select job, count(job) from emp group by job;

babu s

 Profile Answers by babu s 

• Jun 6th, 2011

 

select job count(*)
from emp
group by job;

z_ashwini

 Profile Answers by z_ashwini 

• Jan 13th, 2012

 

Code
 

Iyappan

• Feb 24th, 2012

 

select job, count(job) from emp group by job;