how to get the no employee in each department including the
dept which has 0 employee
Answer Posted / sudipta santra
select distinct dept_no, nvl(count(emp_no),0) from dept
group by dept_no;
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
In what script is snap$ created? In what script is the scott/tiger schema created?
Explain about functional dependency and its relation with table design?
What is system tablespace?
What are the tools for Oracle ?
How to pass a cursor variable to a procedure?
What is recovery manager(rman) backup in Oracle?
Explain what does a control file contain?
What is the difference between post-database commit and post-form commit?
What is the string concatenation operator in oracle?
How to change system global area (sga) in oracle?
How to execute a stored program unit?
What privilege is needed for a user to query tables in another schema?
Explain the use of grant option in imp command.
List the types of joins used in writing subqueries?
What is the minimum client footprint required to connect c# to an oracle database?