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
Answer Posted / madhu sudhan g
Hiii
Try this query it will give you the answer
select count(1) as EmpCount,EmployeeName from EMP
GROUP BY DepartmentName
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of indexing?
Where sql server usernames and passwords are stored in a sql server?
What is a non clustered primary key?
How do you rebuild an identity column?
How to achieve Paging of records in SQL SERVER?
How do you implement session management in SQL Server mode?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is sql server programming?
How to use user defined functions in expressions?
Is foreign key unique?
What is spid in sql server profiler?
Is sql server a database?
What is clustered vs nonclustered index?
What are locks in sql?
What is resource governor?