can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
select e.* from (select row_number() over (order by salary desc) as Rno,* from employee)e where e.Rno = 2
Site Map
