hi folks,

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

Regards
sonia