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
- 7330 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
What is the difference between "as" and "is" in an oracle stored procedure?
How to select some rows from a table in oracle?
How to define an oracle sub procedure?
How to use fetch statement in a loop?
What is recovery manager in Oracle?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How many types of database triggers exist?
What are the extensions used by oracle reports?
How to start your 10g xe server from command line?
What is the data type of dual table?
what is normalisation?what are its uses?
What is raw datatype in oracle?
What are the logical operations?
How do we get field detail of a table?
Why is oracle so popular?
