Thread
:
how to find out the 4th highest value from the column?
View Single Post
#
3
(
permalink
)
12-05-2007, 03:46 AM
Unregistered
Posts: n/a
ANY
answer.
Re: how to find out the 4th highest value from the column?
You can do the same with
[sql]select min(sal) from (select sal from emp where sal is not NULL order by sal desc) where rownum<=&rownum;[/sql]
Unregistered