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
- 8344 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
How many levels of sp nesting is possible?
What do you understand by triggers and mention the different types of it?
What is the log shipping?
Do you know sql server 2008 backup compression?
Is ssrs support other database except ms sql server?
What are the methods used to protect against sql injection attack?
How to use old values to define new values in update statements in ms sql server?
what is a join and explain different types of joins? : Sql server database administration
Can a rule be bound to any column of any data type?
What is instead of trigger sql server?
What is sql collation?
what is the sql equivaent of the dataset relation object ?
Explain what is it unwise to create wide clustered index keys?
What to perform pattern match with the like operator?
How do you run a trace?
