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
- 7112 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanjay pradhan
select d.deptno,count(ename)employees from emp e,dept d
where d.deptno = e.deptno(+)
group by d.deptno
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Point the difference between translate and replace?
What is oracle in java?
How to create a new user account in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is an oracle function?
What is concurrency in oracle?
What is the minimum client footprint required to connect c# to an oracle database?
Explain do view contain data?
What is meant by an index?
what is meant by magic query
What to do if the startbd.bat failed to start the xe instance?
What is java oracle used for?
what is the use of system.effective.date variable in oracle?
What privilege is needed for a user to query tables in another schema?
What is oracle rownum?
