Re: newby top 10

[Quoted] jess <jesskelpie_at_hotmail.com.au> wrote:

>Using SqlPlus I need to select the top ten daily maximum temperatures
>on record from a site with 80 years of record.
>The same temperature may have been recorded more than once and both
>need to be returned.
>I require the first 10 rownumbers I guess
>eg
>07 Dec 2002 43.2
>13 Jan 1956 43
>12 Nov 1982 43
>11 Mar 1938 42.9
>etc

This may be the most asked question in this news group..Does the word 'search' mean anything to you?

Anyway :

select * from (select datefield,temp from table order by temp desc) where rownum < 11;  

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Thu May 01 2003 - 16:02:00 CEST