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
- 8085 Views
- Indecomm, I also Faced
- E-Mail Answers
Answer Posted / rushella
select department_id,count(employee_id) from employees
group by department_id order by department_id;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is a join in sql? What are the types of joins?
Why is replication required on the sql server?
How can we rewrite sub-queries into simple select statements or with joins?
How to find out what is the default collation in a database?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What is auditing in sql server?
Write a sql query to delete duplicate records from a table called table1
What is etl - extraction, transformation, and loading?
What area unit the various kinds of info compression introduced in sql server 2008?
What are the differences between left join and inner join in sql server?
Suggest a method of joining two tables.
whats the maximum size of view state??
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
explain different types of constraints? : Sql server database administration
How to stop log file growing too big?
