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...
selectname,salary from(selectname,salary,row_number()over(orderby salary desc) rowno fromemp_table)where rowno=3; this will not work correctly...
Ya this is working dude
Separate names with a comma.