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
- 7504 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shailesh
select d.department_id,count(e.employee_id) from
departments d
left outer join employees e
on(e.department_id=d.department_id)
group by d.department_id;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / 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 |
Answer / priti
select count(emp_id) from employee group by dept_id;
| Is This Answer Correct ? | 0 Yes | 3 No |
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
What is connection pool in oracle?
What is use of oracle?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
Difference between an implicit & an explicit cursor.?
what is the difference between restoring and recovering?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
What is the difference between substr & instr functions?
How to build data dictionary view an new database?
Respected sir, Please send me technical questions related to oracle apps..
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
How to define a cusotmer as a supplier in ORACLE R12
Oracle General 
