Thursday, 7 March 2013

Second highest salary from employee table

Sort employee table salary in descending order and retrive second row(tuple)


select esal from
 (select esal from hsal 
 order by esal desc)
 where rownum <=2;

No comments:

Post a Comment