Question

write a query to display the number of employees with same job from employees table ​

Answer 1

Answer:

SELECT job,COUNT(*) FROM empGROUP BY job;

lanka_satya. Answered On : Sep 12th, 2008.

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

Answer 2

Answer:

SELECT count(employ_names) from table_name where job_name = name_of_the_job;

Step-by-step explanation:

Following Question is related to Database Management System.

Answer is : SELECT count(employ_names) from table_name where job_name = name_of_the_job;

Here

table_name = Name of the table in which employ names exists.

employ_names= column name of the table in which employ name listed with employs.

Job _name =Column name in which job details are mentioned.

name_of_the_job = required job.

#SPJ3