1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

hi friends please answer this question ASAP:-
how to count the no. of employee in a each department
or
no. of employee in each location by using emp/dept table

Question Posted / amit

Answers were Sorted based on User's Feedback



hi friends please answer this question ASAP:- how to count the no. of employee in a each department..

Answer / madhu sudhan g

Hiii

Try this query it will give you the answer


select count(1) as EmpCount,EmployeeName from EMP
GROUP BY DepartmentName

Is This Answer Correct ?    2 Yes 0 No

hi friends please answer this question ASAP:- how to count the no. of employee in a each department..

Answer / ramandeep singh

SELECT Dept_Name, dept.Dept_ID, COUNT(*) AS 'no. of
employees' FROM dept
LEFT JOIN emp ON emp.Dept_ID = dept.Dept_ID
GROUP BY dept.Dept_ID, Dept_Name

Is This Answer Correct ?    2 Yes 1 No

hi friends please answer this question ASAP:- how to count the no. of employee in a each department..

Answer / sushanta

select dept no, count(dept no)from employee group by dept no.

Is This Answer Correct ?    1 Yes 0 No

hi friends please answer this question ASAP:- how to count the no. of employee in a each department..

Answer / rushella

select department_id,count(employee_id) from employees
group by department_id order by department_id;

Is This Answer Correct ?    1 Yes 1 No

hi friends please answer this question ASAP:- how to count the no. of employee in a each department..

Answer / ezhumalai

select d.dept_ID ,count(empid) from Emp a inner join Department b
on a.empid=b.empid
group by d.dept_ID

Is This Answer Correct ?    0 Yes 0 No

hi friends please answer this question ASAP:- how to count the no. of employee in a each department..

Answer / eswar mudamanchu

For example i am taking Emp table:

Select Deptid,Count(empid) from Emp
Group By Deptid Order By deptid

Select Location,Count(empid) from Emp
Group By Location Order By Location

Is This Answer Correct ?    0 Yes 0 No

hi friends please answer this question ASAP:- how to count the no. of employee in a each department..

Answer / rajkumar v

select Dept_Name,count(Dept_Name) as 'No. of employee'
from tbl_dept group by Dept_Name having COUNT(*)>1

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Does hive support indexing?

0 Answers  

What is attribute relationships, why we need it? : sql server analysis services, ssas

0 Answers  

What are primary keys and foreign keys?

3 Answers  

How do I view a script in sql server?

0 Answers  

What are null values in ms sql server?

0 Answers  




How to find table changes in sql server?

0 Answers  

What is molap and its advantage? : sql server analysis services, ssas

0 Answers  

Explain table valued parameters in sql server? Why tvp used?

0 Answers  

What is store procedure? How do they work? When do you use?

0 Answers  

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

What is dirty read?

0 Answers  

How get current date in SQL server 2000

6 Answers   Cap Gemini,

For more SQL Server Interview Questions Click Here
Categories