delete from emp where (depno,nvl2(sal,sal,0)) in ( select depno,min(nvl2(

Delete the emps whose salaries are lowest sals of their own
dept.

Question Posted / divya chaudhry

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

Please Help Members By Posting Answers For Below Questions

What is sql indexing?

1013

What are database links used for?

1049

what is an index? : Sql dba

1000

How does one load ebcdic data? : aql loader

1178

how many triggers are allowed in mysql table? : Sql dba

1072

What is group by in sql?

1086

What is query optimization in sql?

987

How do you know if a relationship is 2nf?

946

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1015

How many developers work on postgresql?

985

Can a procedure in a package be overloaded?

1045

what is the use of double ampersand (&&) in sql queries?

1176

What is the best partition size for windows 10?

1003

What is rownum?

985

What is the purpose of using pl/sql?

1147