DELETE FROM EMP E1 WHERE E1.SAL = (SELECT MIN(SAL) FROM EMP E2 WHERE

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

Question Posted / raji_4u

Answer Posted / raji_4u

DELETE FROM EMP E1
WHERE E1.SAL =
(SELECT MIN(SAL) FROM EMP E2
WHERE E1.DEPTNO = E2.DEPTNO
)

Is This Answer Correct ?

15 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is rowid in sql?

909

What is delete command in sql?

1053

What are the various restrictions imposed on view in terms of dml?

911

What is the difference between truncate and drop statements?

1086

Can ddl statements be used in pl/sql?

1070

What is pl sql collection?

921

What are the possible values that can be stored in a boolean data field?

950

Can we use pl sql in mysql?

963

Explain the commit statement.

1103

How to use sql statements in pl/sql?

1055

What is a clob in sql?

969

What is sql profiling in oracle?

998

What is data modelling in sql?

964

What is the use of index in sql?

961

Is record in pl sql?

918