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
- 6638 Views
- Indecomm, I also Faced
- E-Mail Answers
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
What is best institute to Learn DotNET And SQL in chennai?
Explain transaction server implicit?
Explain some stored procedure creating best practices or guidelines?
How to rebuild indexes with alter index ... Rebuild?
What are tables in sql server?
Do you know sql server 2008 introduces automatic auditing?
Explain what is the main purpose of having conversation group?
How to list all tables in the database using odbc_tables()?
Tell me in brief how sql server enhances scalability of the database system?
What is the purpose of the model database?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is difference between clustered and non clustered index?
what authentication modes does sql server support? : Sql server database administration
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
