Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Highest Values

Re: Highest Values

From: Dante <dnotari_at_my-dejanews.com>
Date: Wed, 26 May 1999 09:56:19 GMT
Message-ID: <7iggg3$ffm$1@nnrp1.deja.com>


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.--- Received on Wed May 26 1999 - 04:56:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US