delete from emp where (deptno,nvl(comm,0)) in (select deptno,min(nvl(comm

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

Question Posted / roopesh kumar

Answer Posted / roopesh kumar

delete from emp where (deptno,nvl(comm,0)) in (select
deptno,min(nvl(comm,0)) from emp
group by deptno)

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the benefit of foreign key?

1009

What is pl sql script?

1010

what are the types of join and explain each? : Sql dba

1023

What is execution plan in sql?

1021

What is data profiling in sql?

1056

What are the benefits of pl sql?

1106

What are the ddl commands?

990

What is nosql vs sql?

1157

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1181

What is sql partition?

1083

What are secondary keys?

957

Can a foreign key have a different name?

933

Which are sql * plus commands?

1109

What is right join in sql?

1076

What is the left table in sql?

952