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
- 7436 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
Is inner join faster than left join?
Which are the different types of indexes in sql?
What are pl sql data types?
How can we link a sql database to an existing android app?
What is number function in sql?
What is difference sql and mysql?
Do we need to rebuild index after truncate?
What does bitemporal mean?
How does an execution block start and end in pl sql?
Why we use triggers in mysql?
How does sql*loader handles newline characters in a record? : aql loader
What is replication id?
What is the importance of sqlcode and sqlerrm?
What are the different types of dbms?
What is information schema in sql?
