-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|