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
- 8059 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
How to execute stored procedure and set temp table in sql server?
Can group by be used without aggregate functions?
What is triggers in ms sql server?
What are various limitations of the views?
Can a table be created inside a trigger?
what is package and it uses and how can u call a package
What is store procedure?
Explain microsoft sql server functions?
Why we use the openxml clause?
What are the default system databases in sql server 2000?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is partition index in sql server?
What are some examples of schemas?
Which tools are available to manage SQL Azure databases and servers?
What are the differences between union, intersect, and minus operators?
