Interested to Buy Any Domain ? << Click Here >> for more details...
Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10484 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
Is id a reserved word in sql?
Are views faster than queries?
What will you get by the cursor attribute sql%notfound?
explain about mysql and its features. : Sql dba
What's the difference between a primary key and a clustered index?
Show the two pl/sql cursor exceptions.
What does sql stand for?
How do I edit a trigger in sql developer?
Are sql connections encrypted?
How do I get sql certification?
What is a sql instance vs database?
Explain the working of foreign key?
What is program debugging?
how to create a table index in mysql? : Sql dba
what is a foreign key ? : Sql dba
