how to get the no employee in each department including the
dept which has 0 employee
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
What are the predefined tablespaces in a database?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
how may join possible between (requisition with purchase order)
How do I know if oracle is installed on windows?
What is control file used for?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
When do you get a .pll extension in oracle? Explain its importance
What is a package ? What are the advantages of package ?
How to bring a tablespace online?
How to convert character types to numeric types?
What are the extensions used by oracle reports?
How to define a procedure inside another procedure?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to execute a stored program unit?
When do you get a .pll extension in oracle?