ANS-3: SELECT employee_id , department_id FROM employees WHERE departm

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
7587 Views
KPIT, I also Faced
E-Mail Answers

Answer Posted / girija shankar dash

ANS-3:

SELECT employee_id , department_id
FROM employees
WHERE department_id IS NULL;

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the advantage of index in sql?

945

What is sql comments?

1060

What does sql stand for?

975

Is sql easier than java?

990

What is a nested table in word?

945

What is example of database?

1038

What is the difference between a primary key and a clustered index?

969

what are the type of locks ? : Sql dba

944

What is sql select statement?

1014

Can a foreign key be null?

1068

What is the difference between delete and truncate statement in sql?

1045

Explain the components of sql?

1043

Does sql*plus have a pl/sql engine?

1053

what is a trigger? : Sql dba

1011

What are the differences between implicit and explicit cursors?

1049