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?
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 primary key in db?
Why having clause is used in sql?
What are basic techniques of indexing?
Can we change the table name in sql?
How do you add a column to a table?
What is a constraint?
Explain the the delete statements in sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
what is difference between delete and truncate commands? : Sql dba
What is forward declaration in pl sql?
What does an inner join do?
What are the usages of sql?
explain about mysql and its features. : Sql dba
Which is faster joins or subqueries?
What are the types of dbms?