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
- 7329 Views
- I also Faced
- E-Mail Answers
Answer Posted / mahesh madala
select d.deptno,count(ename)no_of_emps from emp e,dept d
where d.deptno = e.deptno(+)
group by d.deptno
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Is oracle a programming language?
How to write a query with a left outer join in oracle?
Is postgres faster than oracle?
What is PL/SQL ?
How to export data with a field delimiter?
Explain what are the different type of segments?
What is not equal to in oracle?
Explain the use of log option in exp command.
How would you go about verifying the network name that the local_listener is currently using?
What are oracle functions?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
Calculate difference between 2 date / times in oracle sql?
What are the varoius components of physical database structure of oracle database?
How to pass a cursor variable to a procedure?
What is private procedure oracle?
