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

Is sql injection illegal?

1002

Explain what is rdbms?

1017

When you have to use a default "rollback to" savepoint of plvlog?

1166

How can get second highest salary in sql?

963

Can we use view in stored procedure?

883

What is the use of desc in sql?

955

What is the difference between having clause and where clause?

1046

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

935

Is it possible to include an insert statement on the same table to which the trigger is assigned?

996

What is sql comments?

1057

What is the trigger in sql?

929

how can we find the number of rows in a table using mysql? : Sql dba

1067

how to return query output in html format? : Sql dba

1057

What has stored procedures in sql?

1046

Does sql view stored data?

935