Could any body post an sql statement to select the N th highest value in a column.
I found one....but had hard time understaning how it works
>select L, max(sal)
from emp where LEVEL=2
where connect prior by sal>sal
group by LEVEL;
Could any body explain what this "connect prior by " is used for.
Pls post if there is any better query