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
- 8655 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 are sql server functions?
Is it possible to have clustered index on separate drive from original table location?
What does set rowcount do?
When does a workload on SQL Azure get throttled?
What are the different types of Indexes available in SQL Server?
What are tables in sql server?
What do you understand by the analysis services in sql server?
how to overcome kernel isssues
What stored by the tempdb ? : sql server database administration
What is primary key index?
What are the features of Embedded SQL
What does the not null constraint do?
How do I install sql server?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
Can we store videos inside the sql server table?
