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
- 8450 Views
- Indecomm, I also Faced
- E-Mail Answers
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
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is the fillfactor concept in indexes?
Does partitioning improve performance sql server?
How and why use sql server?
What are acid properties of transaction?
Do you know clustered and non-clustered index?
Explain raiserror in sql server?
What is lookup override?
Explain filestream storage of sql server 2008?
Explain different forms of normalization?
Explain about the command-line tool SQLCMD?
Can sql servers link to other servers?
How sql server executes a statement with nested subqueries?
Explain transaction server explicit transaction?
