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
- 8074 Views
- Indecomm, I also Faced
- E-Mail Answers
Answer Posted / eswar mudamanchu
For example i am taking Emp table:
Select Deptid,Count(empid) from Emp
Group By Deptid Order By deptid
Select Location,Count(empid) from Emp
Group By Location Order By Location
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How you can change the database name in SQL SERVER?
Why we should not use triggers?
Where do we use trace frag?
How to insert data into an existing table?
How will you make an attribute not process? : sql server analysis services, ssas
Determine how to use the inserted and deleted pseudo tables?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What are the different types of sub-queries?
Will sql server 2005 allow you to reduce the size of a column?
what is a self join? : Sql server database administration
Write SQL queries on Self Join and Inner Join.
Write down the syntax and an example for create, rename and delete index?
Explain query editor regions
What is a database table?
Can the “if update (colname)” statement be used in a delete trigger?
