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
7642 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 a composite key ? : Sql dba

1065

What is data type in sql?

967

What is inner join in sql?

1084

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1075

What is denormalization in a database?

1057

What is online transaction processing (oltp)?

1018

Explain what is table in a database?

1062

How many columns should be in an index?

963

Does sql backup shrink transaction log?

983

How is a PL/SQL code compiled?

1236

Is primary key is clustered index?

1002

Are left and right joins the same?

1088

what is try_catch block in procedure

1753

What are the basic sql commands?

1095

Is sql easier than java?

1018