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: Oracle NetNews <joey.ogalesco_at_bigfoot.com>
Date: Wed, 26 May 1999 23:05:49 -0400
Message-ID: <7iid5c$ksj$1@bgtnsc03.worldnet.att.net>


select col1, col2, col_number
from (select distinct col_number from my_table order by col_number desc) where rownum <= 50

rpereira_at_my-dejanews.com wrote in message <7if1gq$ea2$1_at_nnrp1.deja.com>...
>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.---
Received on Wed May 26 1999 - 22:05:49 CDT

Original text of this message

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