Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 9561 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagendra
delete from emp where sal in (select min(sal) from emp group
by deptno)
| Is This Answer Correct ? | 7 Yes | 7 No |
Post New Answer View All Answers
What is the difference between local and global temporary table?
How do you update sql?
What is the difference between a primary key and a clustered index?
Explain two easy sql optimizations.
What does 0 mean in sql?
Can we commit in trigger?
What is recursive join in sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
give the syntax of grant and revoke commands? : Sql dba
What is dense_rank?
What is a schema sql?
What is the starting oracle error number?
What is difference between table and view?
Why query optimization is needed?
What is blind sql injection?
