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
- 7320 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
Why do we need integrity constraints in a database?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Explain the dml?
What is a table in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to experiment a data lock in oracle?
What is an oracle recycle bin?
How to commit the current transaction in oracle?
Which is faster join or subquery in oracle?
List the parts of a database trigger.
How to create a new user account in oracle?
Explain enable novalidate constraint.
What is flashback in Oracle?
Difference between pre-select and pre-query
What is an oracle and why it is used?
