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?
Answers were Sorted based on User's Feedback
Answer / ramya pisharody
Ans-1:
SELECT DEPTNO, COUNT(*) FROM EMP
GROUP BY DEPTNO
HAVING COUNT(*)>10;
Is This Answer Correct ? | 3 Yes | 0 No |
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 |
ANS-3:
SELECT employee_id , department_id
FROM employees
WHERE department_id IS NULL;
Is This Answer Correct ? | 2 Yes | 1 No |
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 |
how many groups of data types? : Sql dba
What is the purpose of the sql select top clause?
what is unique key constraint? : Sql dba
How many tables can a sql database have?
Explain character-manipulation functions?
What is procedure in pl sql?
Can we create index on primary key?
what are rollup and cube in t-sql? : Transact sql
What is the purpose of normalization?
What is sql partition?
What are pl/sql packages?
How many types of functions are there in sql?