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
- 8345 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 make conditional sum in ssrs?
Explain datetimeoffset data type in sal server 2008?
What are the different kinds of ssrs reports?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What does set rowcount do?
What are the acid properties?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How to delete duplicate rows?
What is normalization 1nf 2nf 3nf?
What is the standby server?
Why SQL Agent is used?
In case you have filters in your report, when filters will be applied in cached report instance?
What is the recovery model?
Write query to return all rows sql?
Explain about builtinadministrator?
