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
- 7493 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
Explain drop constraint oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to update a table row with a record?
How to drop an existing table in oracle?
How to list all tables in your schema?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Why do we use coalesce function in oracle?
Explain view?
What is connection pooling in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is a sub query? Describe its types?
How to create a testing table in oracle?
What is Segment Advisor in Oracle?
Can we call procedure inside function in oracle?
How can we create the complete backup of data in the oracle.
