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 coalesce in sql?

970

What is sql not null constraint?

981

What is data manipulation language?

1134

What is procedure function?

981

Does mysql_real_escape_string prevent sql injection?

907

What is the unique index?

1003

What are the two types of exceptions in pl/sql?

965

What is sql and explain its components?

1007

What is a variable in sql?

950

what is sql profiler? : Sql dba

994

What is the default isolation level in sql server? : Transact sql

962

what is the difference between union and union all? : Sql dba

974

What is cursor in pl sql?

1050

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

941

how tsql statements can be written and submitted to the database engine? : Transact sql

921