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
- 7787 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 will you distinguish a global variable with a local variable in pl/sql?
Why is sql*loader direct path so fast?
How to run sql statements through the web interface?
How can you create an empty table from an existing table?
What is compiled query?
Is a foreign key always unique?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is oracle and pl sql?
Which certification is best for sql?
Which table is left in join?
How do I know if I have sql express or standard?
how to use myisamchk to check or repair myisam tables? : Sql dba
what are the security recommendations while using mysql? : Sql dba
how to shutdown mysql server? : Sql dba
What is the sql case statement?
