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
- 7487 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
Can multiple columns be used in group by in oracle?
defination of bitmap index
definition of cluster and non-clustered index?
What is the difference between $oracle_base and $oracle_home?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is Undo Management Advisor in Oracle?
What is meant by joins? List out the types of joins.
How do you store pictures in a database?
What is a sub query? Describe its types?
What is the meaning of recursive hints in oracle?
what is port in oracle? how is it related to database application.
How to export your own schema?
How to invoke the original export import utilities?
What is the minimum client footprint required to connect c# to an oracle database?
