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
- 7788 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
Does sql backup shrink transaction log?
Which query operators in sql is used for pattern matching?
Is primary key always clustered index?
Why schema is used in sql?
Mention what pl/sql package consists of?
how to use myisamchk to check or repair myisam tables? : Sql dba
Explain the the update statement in sql?
What is meant by temporal data?
What is cursor status?
What is the sql case statement?
what is 'mysqlcheck'? : Sql dba
What does a pl/sql package consist of?
Is sql a oracle?
What does sign mean sql?
Does sql full backup truncate logs?
