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
- 7586 Views
- KPIT, I also Faced
- E-Mail Answers
Answer Posted / girija shankar dash
ANS-2:
SELECT department_id,COUNT(employee_id) AS "NO. OF EMPLOYEES"
FROM employees
GROUP BY department_id
HAVING COUNT(employee_id) = 0;
DEPARTMENT_ID NO. OF EMPLOYEES
201 0
311 0
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How do I make sql search faster?
What is the mutating table and constraining table?
What is composite primary key in sql?
what is datawarehouse? : Sql dba
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is a procedure in pl sql?
How many sql statements are used?
What mean sql?
How do you delete a table?
Which is better join or subquery?
how to concatenate two character strings? : Sql dba
Is sql a backend?
Which sql most popular?
What is a database? Explain
Name the operator which is used in the query for pattern matching?
