Someone showed me (outside of this forum) that this is not correct.
Generally, the order-by is evaluated AFTER building the ROWNUMs. So the
solution will not always work.
I tried it before and it obviously worked - most probably because i
chose to order descending by the primary key.
Arnold Schommer wrote:
>
> vvraghav_at_my-dejanews.com wrote:
> >
> > hi ,
> > i am just learning sql (using sql plus 3.3 with PO7win95) .
> > i have an assignment i have to complete -
> > to find the nth maximum value from a given list ....
> > say i want to find the 2nd maximum from the following list
> >
> > sno (primary key) marks
> > 1 100
> > 2 102
> > 3 101
> > 4 97
> > the output should be (3 101) and the catch is i shouldnt use
> > pl/sql programs , only simple queries.
> > (even if order by using marks, how do i print only the nth row?)
> > vikram , india
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
> try rownum. (This is a pseudo-column). assuming the above table is
> called "rankings", it should be:
>
> select sno, marks
> from rankings
> where rownum = 2
> order by marks desc;
>
> maybe this helps you.
>
> Arnold Schommer
Received on Wed Mar 24 1999 - 09:52:56 CST
