Q1.all the depts which has more then 10 empls? Q2.all the dept which does not h

Q1.all the depts which has more then 10 empls?
Q2.all the dept which does not have any emply?
Q3 all the emp which does not have any dept?
Q4 get all the emply detais with the dept details it dept is
exit otherwise any emp details?
Q5 how to debugg the dynamic sql and packages?

Question Posted / gouri sankar

4 Answers
7877 Views
KPIT, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 a..

Answer / ramya pisharody

Ans-1:

SELECT DEPTNO, COUNT(*) FROM EMP
GROUP BY DEPTNO
HAVING COUNT(*)>10;

Is This Answer Correct ?

3 Yes

0 No

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 a..

Answer / girija shankar dash

ANS-2:

SELECT department_id,COUNT(employee_id) AS "NO. OF EMPLOYEES"
FROM employees
GROUP BY department_id
HAVING COUNT(employee_id) = 0;

DEPARTMENT_ID NO. OF EMPLOYEES
201 0
311 0

Is This Answer Correct ?

3 Yes

2 No

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 a..

Answer / girija shankar dash

ANS-3:

SELECT employee_id , department_id
FROM employees
WHERE department_id IS NULL;

Is This Answer Correct ?

2 Yes

1 No

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 a..

Answer / ajit

ANS - 2
select d.deptno, dname, loc
from emp e, dept d
where e.deptno(+) = d.deptno
and e.deptno is null;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer