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

Is sql scripting language?

1032

How to write html code in pl sql?

1098

What is scalar and vector?

986

Explain the uses of database trigger.

1097

What is left join example?

934

How delete all data from table in sql?

1004

What are all the different normalization?

1024

What is a sql schema used for?

1080

Where the sql database files are stored?

1000

How to get list of all tables from a database?

1139

What are the two types of cursors in pl sql?

1059

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1199

What is mutating trigger?

1004

What is form and report?

960

What is the usage of nvl function?

1025