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
- 8075 Views
- Indecomm, I also Faced
- E-Mail Answers
Answer Posted / sushanta
select dept no, count(dept no)from employee group by dept no.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of floor function?
What is the difference between dbcc indexdefrag and dbcc reindex?
What are the common performance issues in sql server?
How to change the ownership of a schema in ms sql server?
How do I install sql server?
How does index makes search faster?
What is raid and what are different types of raid levels?
What is a rownum?
Scalability, Availability, Integration with internet, etc.)?
What is the purpose of sql profiler in sql server?
What is clustered primary key?
Do you know what is a trace frag? Where do we use it?
Explain what are page splits? : SQL Server Architecture
When do you think a developer should use sql server-based cursors?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
