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


Please Help Members By Posting Answers For Below Questions

What are the ways on commenting in a pl/sql code?

512


What is trigger in flip flop?

518


What are the two different parts of the pl/sql packages?

566


Why is there a need for sqlcode and sqlerrm variables?

587


How to call a javascript function from pl sql?

565






What is sap sql?

536


Does truncate remove indexes?

563


What is column?

550


How to avoid using cursors?

599


what is a constraint? : Sql dba

715


What is an inner join sql?

547


what is the difference between myisam static and myisam dynamic? : Sql dba

585


What is example of database?

519


How many rows can sqlite handle?

587


What is nosql example?

583