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
- 8076 Views
- Indecomm, I also Faced
- E-Mail Answers
Answer Posted / rajkumar v
select Dept_Name,count(Dept_Name) as 'No. of employee'
from tbl_dept group by Dept_Name having COUNT(*)>1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What do you mean by normalisation?
What does it mean to be in union?
what is denormalization and when would you go for it? : Sql server database administration
How to find related tables in sql server?
What is BCP? When does it used in sql server 2012?
Explain the microsoft sql server delete command? : SQL Server Architecture
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Is foreign key unique?
How to name query output columns in ms sql server?
How will you optimize a stored procedure optimization?
What do you do in data exploration
Explain transaction server implicit?
What do you understand by coalesce in sql server?
What is the meaning of sql server?
What is the name of reporting services config file and what’s it’s used for?
