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
7426 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 are sql indexes?

932

How do you update f as m and m as f from the below table testtable?

1787

How long does it take to learn pl sql?

999

what is msql? : Sql dba

939

What are the disadvantages of file system?

1161

Is ms sql is free?

951

What does where 1/2 mean in sql?

1006

What are triggers in sql?

971

what is a table in a database ? : Sql dba

989

How to create your own reports in sql developer?

971

What is difference between left and right outer join?

931

what are the disadvantages of mysql? : Sql dba

1074

Which are the different case manipulation functions in sql?

952

what is a foreign key ? : Sql dba

1025

what are date and time intervals? : Sql dba

998