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
- 7486 Views
- I also Faced
- E-Mail Answers
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
What is a database table in oracle?
How to count groups returned with the group by clause in oracle?
How to retrieve data from an explicit cursor?
How to create a stored function in oracle?
What is Trigger in Oracle?
How to create a table index in oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is a subquery in oracle?
Explain about the analyze command in oracle?
How to best split csv strings in oracle 9i?
Why does for update in oracle 8 cause an ora-01002 error?
List out the difference between commit, rollback, and savepoint?
What is index in Oracle?
