ANS-2: SELECT department_id,COUNT(employee

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 / girija shankar dash

4 Answers
7813 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

Please Help Members By Posting Answers For Below Questions

What is dml with example?

1158

What are the different operators available in sql?

1061

What are sql indexes?

1052

how to use in conditions? : Sql dba

1070

What are analytic functions in sql?

1078

Can you rollback after commit?

1059

what is blob? : Sql dba

1235

What does select top 1 do in sql?

1149

Are views faster than queries?

1050

Is sql easier than java?

1079

What is program debugging?

1359

What is sap sql?

1033

How to read xml file in oracle pl sql?

958

How do temporal tables work?

1028

What is the difference between mdf and ndf files?

1171