Re: select nth row ?

Hi,

Try the following:

create index I_TAB on TAB (COL);

select COL, COL1, ...
from ( select COL, COL1, ...rownum RR from TAB

           where COL >= ( select min(COL) from TAB) ) where RR = NTH_ROW;

    Elena

Phil R Lawrence wrote:

> I am treating the results of an ordered query as a data set. As such, I am
> interested in determining the mean and interquartile range. This means I need
> to be able to select the nth row of the *ordered* data set.
Received on Fri Apr 24 1998 - 06:25:43 CDT