Interested to Buy Any Domain ? << Click Here >> for more details...
Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10720 Views
- I also Faced
- E-Mail Answers
Answer Posted / divya chaudhry
delete from emp where (depno,nvl2(sal,sal,0)) in ( select
depno,min(nvl2(sal,sal,0)) from emp group by depno )
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are the qualities of 2nf?
Can a view be mutating? If yes, then how?
What is sql resultset?
What are %type and %rowtype for?
Is drop table faster than truncate?
What are the events on which a database trigger can be based?
What do we need to check in database testing?
What is use of term?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Write a sql query to get the third highest salary of an employee from employee_table?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is dcl in sql?
Mention what are the benefits of pl/sql packages?
What is difference between sql function and stored procedure?
what is sp_pkeys? : Transact sql
