Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8442 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 are the benefits of filtered indexes?
What is the use of RDBMS?
How to delete all rows with truncate table statement in ms sql server?
What is a synonym for manipulation?
How to delete duplicate rows?
How to call a function from a stored procedure in SQL Server ?
How many types of attribute relationships are there? : sql server analysis services, ssas
What are sparse columns?
Explain about the command-line tool SQLCMD?
What are the types of database recovery models?
What are basics of policy management?
what are different types of raid configurations? : Sql server database administration
What is the stuff and how does it differ from the replace function?
How do I view a trc file?
explain declarative management framework (dmf) in sql server 2008?
