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
- 7098 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 the difference between post-database commit and post-form commit?
Compare and contrast between sql and sql server and explain its various functions?
When system tablespace is created?
Can you have more than one content canvas view attached with a window ?
How to execute the package in oracle?
How to connect ms access to oracle servers?
What is difference between cartesian join and cross join?
How to assign values to variables?
What are data pump export and import modes?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
How to retrieve data from an explicit cursor?
What is the relationship among database, tablespace and data file?
How to define an explicit cursor in oracle?
What is recycle bin in Oracle?
What is coalesce function?
