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
- 6640 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
What is join query?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What are number line correlation administrators will use while working with a subquery?
Can a unique index be created on a column, which contains null?
If user is owning any SQL Objects, can we drop that user
What is a hint?
How do I debug a stored procedure in sql server?
How to use subqueries with the in operators in ms sql server?
What is query processing?
How to disable a login name in ms sql server?
what data regions are and what are the different data regions?
How many types of objects are there?
What is a database table?
What is a Join and explain its types?
what is denormalization? : Sql server database administration
