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
- 6641 Views
- Indecomm, I also Faced
- E-Mail Answers
Answer Posted / ezhumalai
select d.dept_ID ,count(empid) from Emp a inner join Department b
on a.empid=b.empid
group by d.dept_ID
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Do you know sql server 2008 backup compression?
Explain relational data?
How to insert multiple rows with a subquery?
What is the need for indexing?
Define primary key?
Explain about sql server login?
What are the different types of subquery?
How to turn on the mssql api module in php?
How can we remove orphan records from a table?
what is a join? : Sql server database administration
How dts is used to extract, transform and consolidate data?
What is the difference between a clustered index and a non-clustered index?
Do you know hot add cpu in sql server 2008?
What is sql server schema compare? How we can compare two database schemas?
How to list all user names in a database?
