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
- 7104 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
How to get execution statistics reports on query statements?
Where do you use decode and case statements?
Explain the use of compress option in exp command.
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
Explain temporal data types in oracle
How to store only time; not date and time?
How to do paging with oracle?
How to set up autotrace for a user account?
What is the dynamic sql in oracle?
How to do clean up if create database failed?
What are the ways tablespaces can be managed and how do they differ?
How to retrieve the count of updated rows?
What is procedure overloading in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What happens in oracle commit?
