Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 9568 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 is not null in sql?
What do you understand by case manipulation functions?
What is partition in sql query?
How do I use google cloud in sql?
what are the types of join and explain each? : Sql dba
Can we join more than 2 tables in sql?
Which one is better sql or oracle?
What are the types of keys?
Explain the types of joins in sql?
What is full join?
Can unique keys be null?
What is the difference between having and a where in sql?
what is column? : Sql dba
Can we use pl sql in sql server?
Explain what is a database?
