Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 7660 Views
- KPIT, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why do we need cursor in pl sql?
Is sql developer case sensitive?
Enlist the characteristics of pl/sql?
Can a varchar be a primary key?
Is join and inner join the same?
How do you sort in sql?
What is procedure explain with example?
How can we implement rollback or commit statement in a trigger?
What plvcmt and plvrb does in pl/sql?
How to add, remove, modify users using sql?
What is duration in sql profiler trace?
what is a cursor? : Sql dba
What is a pdo connection?
Explain how can you save or place your msg in a table?
what is primary key? : Sql dba
