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 trigger explain it?

1080

Can you select everything, but 1 or 2 fields, without writer's cramp?

1042

How do I start sql from command line?

1084

What is posting?

1086

What is scalar data type in pl sql?

1119

what is the difference between truncate and drop statements? : Sql dba

1188

Why stored procedures are faster than query?

1079

What is inner join in sql?

1139

What are local and global Indexes and where they are useful.

1499

How many sql commands are there?

1161

What is the execution plan in sql?

1072

What is pl sql in oracle?

1101

What is substitution variable?

1100

what are the security recommendations while using mysql? : Sql dba

1183

What is the sql query to display the current date?

1094