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
- 7644 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
How can we debug in PL/SQL?
How to connect a sql*plus session to an oracle server?
Why cross join is used?
What is memory optimized table?
How to Declare Fixed Length String Value In PL SQL
What schema means?
What does select * from mean in sql?
how to present a past time in hours, minutes and seconds? : Sql dba
What are functions in sql?
How to run sql functions in pl/sql?
What is cte?
how to rename an existing column in a table? : Sql dba
What is cursor explain with example?
How do you use join?
How do you write an inner join query?
