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
- 8058 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
Where is trigger in sql server?
Explain full-text query in sql server?
What is a join in sql? What are the types of joins?
What are data resources?
Disadvantages of the indexes?
How do you make a trace?
what is a correlated sub-query? : Sql server database administration
What are different types of statements that are supported by sql?
What are trace flags?
Explain the truncate command? : SQL Server Architecture
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
How to check if stored procedure is running in sql server?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
Is oracle faster than sql server?
Does any body please help me what question's have asked for SSRS in the interview?
