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
- 7777 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 tsql statements can be written and submitted to the database engine? : Transact sql
Explain spool.
What is difference between sql function and stored procedure?
What is natural join in sql?
What can I use instead of union in sql?
Enlist the characteristics of pl/sql?
Explain what is an index?
What is optimistic concurrency control? : Transact sql
How do I write a cron which will run a sql query and mail the results to agroup?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is error ora-12154: tns:could not resolve the connect identifier specified?
what is “go” in t-sql? : Transact sql
What does the hierarchical profiler does?
What are the different sql commands?
How do I count rows in sql?
