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
- 5423 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 sql aggregate functions?
How to write a query to show the details of a student from students table whose
What is sql and explain its components?
What is range partitioning?
What is cross join sql?
What is a heap in sql?
What are the usages of sql?
What is dynamic sql in pl sql?
What is full join?
What is difference between sql and excel?
What is difference between joins and union?
What are transaction and its controls?
When sql appeared?
How do you update f as m and m as f from the below table testtable?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
