Re: Highest Values

From: <shiling_at_math.wayne.edu>
Date: Wed, 26 May 1999 12:33:48 GMT
Message-ID: <7igpnd$lk2$1@nnrp1.deja.com>

Does 'order by' work in subquery in Oracle 8??????

In article <7iggg3$ffm$1_at_nnrp1.deja.com>, Dante <dnotari_at_my-dejanews.com> wrote:
> This seems to work in Oracle 8 or 8i only:
>
> select *
> from (select *
> from mytable
> where <wherecondition>
> order by <the column which holds the values> desc
> )
> where rownum <= 50
>
> Regards
> Dante
>
> In article <7if1gq$ea2$1_at_nnrp1.deja.com>,
> rpereira_at_my-dejanews.com wrote:
> > How can I get the 50's highest values in a column (number datatype)
> > reading a table with one hundred of lines ?
> >
> > important: Using SQL (non PL-SQL)
> >
> > --== Sent via Deja.com http://www.deja.com/ ==--
> > ---Share what you know. Learn what you don't.---
> >
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 26 1999 - 07:33:48 CDT