Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 9567 Views
- I also Faced
- E-Mail Answers
Answer Posted / roopesh kumar
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 |
Post New Answer View All Answers
What does <> sql mean?
What is the difference between sum and count in sql?
What steps server process has to take to execute an update statement?
Does inner join return duplicate rows?
What are different types of triggers?
How to order siblings in oracle hierarchy queries?
What is the difference between inner join and left join?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is sql partition?
What are the three forms of normalization?
how to load data files into tables with 'mysqlimport'? : Sql dba
what is sql server agent? : Sql dba
What is the purpose of the sql select top clause?
What is function and procedure?
Can a foreign key be null?
