Interested to Buy Any Domain ? << Click Here >> for more details...
Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10698 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of joins in sql?
what are date and time intervals? : Sql dba
Why primary key is required?
What does count (*) do in sql?
Is sql easier than java?
What is pls integer?
Does inner join return duplicate rows?
which types of join is used in sql widely? : Sql dba
What do you understand by pl/sql cursors?
What is sql and how does it work?
What are the types of dbms?
What does varchar include?
write an sql query to find names of employee start with 'a'? : Sql dba
how can we know the count/number of elements of an array? : Sql dba
How can you get sql*loader to commit only at the end of the load file? : aql loader
