Re: Highest Values

In 8.0.x+ it does

Regards
Dante

In article <7igpnd$lk2$1_at_nnrp1.deja.com>,   shiling_at_math.wayne.edu wrote:
> 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.---
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 27 1999 - 04:24:43 CDT