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
- 7490 Views
- I also Faced
- E-Mail Answers
Answer Posted / mahesh madala
select d.deptno,count(ename)no_of_emps from emp e,dept d
where d.deptno = e.deptno(+)
group by d.deptno
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to execute a stored procedure in oracle?
How to assign values to data fields in record variables?
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??
How to insert a new row into a table in oracle?
How to define a variable to match a table column data type?
What is oracle database client?
Is there any function in oracle similar like group_concat of mysql?
What are the components of logical database structure in oracle database?
What is a dead lock in oracle?
What is the use of file param in imp command?
Explain the use of Merge statement in oracle 11g
What are the differences between char and varchar2 in oracle?
Explain a synonym?
Explain the use of rows option in imp command.
What is the Tune Query
