Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10849 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
Can we use distinct and group by together?
What is your daily office routine?
Is primary key always clustered index?
what is bcp? When does it used? : Sql dba
what is dbms? : Sql dba
Is primary key clustered index?
How do I remove duplicates in two columns?
what are aggregate and scalar functions? : Sql dba
Does group by remove duplicates?
Can delete statement be rollbacked?
What is the current version of sql?
define sql insert statement ? : Sql dba
Can we rollback truncate?
If a cursor is open, how can we find in a pl/sql block?
what is schema? : Sql dba
