Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the no employee in each department including the
dept which has 0 employee
- 5 Answers
- 7324 Views
- I also Faced
- E-Mail Answers
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
What is the difference between truncate & delete command?
How to export your own schema?
How to delete a column in an existing table in oracle?
How to use "while" statements in oracle?
What is using clause and give example?
Can a parameter be passed to a cursor?
What is concurrency in oracle?
How would you change old and new values in an insert, delete and update triggers?
does the query needs a hint to access a materialized view?
What are ddl statements in oracle?
What is the exact use of Collections?
Does oracle partitioning improve performance?
Explain the dml?
What is rich query?
What is the use of oracle?
