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
- 6295 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
What is the process of normalising?
How to Update from select query in sql server?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What is rtm version in sql server?
What are various aggregate functions that are available?
what is a transaction? : Sql server database administration
Does index slows down insert statements?
What is the default schema of your login session in ms sql server?
Is port 1433 secure?
How check triggers in sql server?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What do you think of this implementation? Can this be implemented better?
Difference between Logical Page and Physical Page in SSRS.
Explain magic tables in sql server?
How to fine-tune reports?
