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
- 8437 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
What is acid properties?
How many replicas are maintained for each sql azure db?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What is sql azure database?
How to make a column nullable?
What do you need to connect php to sql server?
What should be the fill factor for indexes created on tables? : sql server database administration
what is the maximum size of a row? : Sql server database administration
What is attribute relationships, why we need it? : sql server analysis services, ssas
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What is scheduled job and how to create it?
What do you think of this implementation? Can this be implemented better?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
