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
- 7588 Views
- KPIT, I also Faced
- E-Mail Answers
Answer Posted / ramya pisharody
Ans-1:
SELECT DEPTNO, COUNT(*) FROM EMP
GROUP BY DEPTNO
HAVING COUNT(*)>10;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is trigger price?
List the different type of joins?
how to calculate the difference between two dates? : Sql dba
what is rollback? : Sql dba
How do I quit sql?
Which are the different types of indexes in sql?
Can we change the table name in sql?
How do you use collections in procedure to return the resultset?
What does the hierarchical profiler does?
Can %notfound return null after a fetch?
How many types of triggers exist in pl/sql?
What is thread join () in threading?
What is the difference between union and union all command?
What is the purpose of normalization?
Why triggers are used?
