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
- 8635 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 the class forname () does?
How can I tell if sql server is 32 or 64 bit?
How we can compare two database data?
Explain the Ways to improve the performance of a sql azure database?
Explain what is the difference between union and union all?
What is ms sql server service broker?
What happens if you insert a duplicate key for the primary key column in ms sql server?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
How to see existing views in ms sql server?
When we should use @@error?
Explain what is cte (common table expression)?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
How can I get data from a database on another server?
Define full outer join in sql server joins?
