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
- 8441 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
How will you go about resolving deadlocks?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
When would you use sql joins?
What happens to a trigger with multiple affected rows?
What is the maximum length of an alert name?
Does index slows down insert statements?
How can I check if a view exists in a sql server database?
Do you know what is normalization of database? What are its benefits?
What are data regions?
How do triggers work?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is exclusive locks?
What are ddl (data definition language) statements for tables in ms sql server?
How do I view a stored procedure in sql server query?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
