PRASOON's Avatar, Join Date: Jun 2010
Newbie Member
selectname,salary from(selectname,salary,row_number()over(orderby salary desc) rowno fromemp_table)where rowno=3;
this will not work correctly in the case where the salaries are repeating .....
PRASOON's Avatar, Join Date: Jun 2010
Newbie Member
select sal from(select sal,row_number() over(order by sal

desc) rowno from emp group by sal) where rowno= &<nth salary>


this i guess should be give correct results in all cases