delete from emp where sal in (select min(sal) from emp group by deptno)

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

Question Posted / nagendra

Answer Posted / nagendra

delete from emp where sal in (select min(sal) from emp group
by deptno)

Is This Answer Correct ?

7 Yes

7 No

Please Help Members By Posting Answers For Below Questions

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1087

Which are the different case manipulation functions in sql?

1027

How to call a javascript function from pl sql?

1143

Is left join same as inner join?

1134

What is sql server and ase?

1029

What is dml and ddl?

960

What is embedded sql in db2?

1022

Can we use ddl commands in pl sql?

1164

What is Collation Sensitivity ? What are the various type ?

954

What are keys in sql?

1004

what is an extent ? : Sql dba

1105

what is a control file ? : Sql dba

1045

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

963

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1237

Is coalesce faster than isnull?

967