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
- 8652 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 understand by triggers and mention the different types of it?
Explain the properties of subqueries in sql server?
What is ems sql management studio? : sql server management studio
Why we need to use secondry database file? though, we can do same work using primary database file also.
Explain the difference between delete,drop and truncate in SQL Server?
What are pessimistic lock and optimistic lock?
What is failover clustering overview?
Can we use custom code in ssrs?
Define ACID properties in a Database?
What do you mean by acid?
How to fetch the next row from a cursor with a "fetch" statement?
What is always encrypted?
what is a mixed extent? : Sql server administration
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What is a cube? : sql server analysis services, ssas
