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

Explain the structure of pl/sql in brief.

1044

What are field types?

942

how many columns can be used for creating index? : Sql dba

899

What is denormalization in a database?

995

How do you concatenate in sql?

975

What is a boolean in sql?

946

Can a table have no primary key?

1010

what is a foreign key ? : Sql dba

1028

What are the types of join and explain each?

989

How do I run a sql query in pgadmin 4?

906

Is sql sequential or random?

983

What is a sql schema used for?

1031

Can 2 queries be executed simultaneously in a distributed database system?

1084

Explain the uses of database trigger.

1055

Explain the working of primary key?

1038