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
- 8653 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
Do you know the cursor types?
How sql server executes a statement with nested subqueries?
Can we call stored procedure in view in sql server?
What are commit and rollback in sql?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Do you know what is a with(nolock)?
Explain the different types of joins?
Explain what are the restrictions while creating batches in sql server?
What is subquery explain with example?
What are the different type of replication in sql server?
System variable and temporary variables
Can we write trigger for view?
What is purpose of normalization?
What do you mean by recursive stored procedure?
What is co-related sub query?
