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