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?
- 2 Answers
- 5335 Views
- I also Faced
- E-Mail Answers
Answer Posted / krish
1)select deptno,count(*)
from emp having count(*)=0 group by deptno;
2)select deptno,count(*)
from emp having count(*)>10 group by deptno;
3)select empname from emp where deptno is null;
4)select emp.deptno,emp.ename,dept.deptno,dept.dname
from emp,dept
where emp.deptno=dept.deptno(+);
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What are the three forms of normalization?
How do I run a script in sql developer?
Which join is like an inner join?
What is having clause in sql?
What is not null in sql?
How many sql core licenses do I need?
What is the requirement of self-join?
What are all the common sql functions?
How do I delete a trigger?
What is before and after trigger?
What is data manipulation language?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is memory optimized?
What is break?
What is procedure in pl sql?
