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
- 7 Answers
- 6307 Views
- Indecomm, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define clusters?
How to check parameter value in stored procedure sql server?
How do you handle datasets larger than 50 gb?
What is an identity column in insert statements?
When should you use an instead of trigger?
What is importing utility?
what are isolation levels? : Sql server database administration
Does view occupy space?
What is the distinction amongst delete and truncate?
How to create user messages with print statements in ms sql server?
Explain the microsoft sql server delete command? : SQL Server Architecture
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is join query?
How to select true false based on column value in sql server?
Do you know what are the differences between lost updates and uncommitted dependencies?
