how to get the no employee in each department including the
dept which has 0 employee
Answer Posted / shailesh
select d.department_id,count(e.employee_id) from
departments d
left outer join employees e
on(e.department_id=d.department_id)
group by d.department_id;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why oracle is used?
How to loop through data rows in the implicit cursor?
How does one get the view definition of fixed views/tables?
Explain the blob datatype?
How to rename an index?
Which is faster join or subquery in oracle?
What does sharding mean?
Can I create users through internet explorer in oracle 10g?
How to connect to a local oracle 10g xe server?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Which are the five query types available in oracle?
Explain the use of indexes option in imp command.
List out the components of logical database structure of oracle database.
What is a connect identifier?
What is a system tablespace?