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
- 7494 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
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
what are properties of a transaction? : Sql dba
What is union?
What is the use of prepared statement?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is record in pl sql?
What are three advantages to using sql?
Why do we use cursors?
How many tables can a sql database have?
How to display the records between two range in Oracle SQL Plus?
what is the bond code in materialized view?
How to return an array from java to pl/sql?
How to handle bulk data?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
