Query for second maximum salary in each in each department
Answer Posted / nancy singhal
select max(salary) from emp where salary in(select salary
from emp where salary not in(select max(salary) from emp));
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are the ways on commenting in a pl/sql code?
What is trigger in flip flop?
What are the two different parts of the pl/sql packages?
Why is there a need for sqlcode and sqlerrm variables?
How to call a javascript function from pl sql?
What is sap sql?
Does truncate remove indexes?
What is column?
How to avoid using cursors?
what is a constraint? : Sql dba
What is an inner join sql?
what is the difference between myisam static and myisam dynamic? : Sql dba
What is example of database?
How many rows can sqlite handle?
What is nosql example?