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
Answer Posted / 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 |
Post New Answer View All Answers
can any body tell me how to know the password of current user in sql server
How do I edit a procedure in sql server?
What do you understand by intent locks?
Write the syntax for stuff function in an sql server?
How to update a field in SQL after ALTERING a row?
What Are the Main Features of SQL Azure?
What is the new security features added in sql server 2014? : sql server security
How many triggers you can have on a table?
What are types of storage modes? : sql server analysis services, ssas
How to modify existing triggers using "alter trigger"?
What is the difference between truncate and delete commands?
what are the three command line utilities and what are their primary functions?
What does REVERT do in SQL Server 2005?
Explain time data type in sal server 2008?
Explain active/passive and active/active cluster configurations?