Delete the emps whose salaries are lowest sals of their own
dept.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nagendra
delete from emp where sal in (select min(sal) from emp group
by deptno)
| Is This Answer Correct ? | 7 Yes | 7 No |
Answer / venkyhulk1
delete from emp where eno in
(SELECT
eno
FROM
(select eno, rank() over ( partition by dno order by
salary) rank , salary from emp) e
WHERE
e.rank=1)
vgupalli@gmail.com
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / divya chaudhry
delete from emp where (depno,nvl2(sal,sal,0)) in ( select
depno,min(nvl2(sal,sal,0)) from emp group by depno )
| Is This Answer Correct ? | 0 Yes | 3 No |
delete from emp where (deptno,nvl(comm,0)) in (select
deptno,min(nvl(comm,0)) from emp
group by deptno)
| Is This Answer Correct ? | 0 Yes | 4 No |
What is the main reason behind using an index?
What are the different dml commands in sql?
What are the types of keys?
Can we use out parameter in function?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
In packages the source code is compiled into p code ? how do we describe the p code
what is index? : Sql dba
What is different between union and minus?
What is the difference between microsoft sql and mysql?
How long does it take to learn pl sql?
When sql appeared?
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)