Re: newby top 10

On Thu, 01 May 2003 09:02:00 -0500, TurkBear <john.greco_at_dot.state.mn.us> wrote:

>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 =---

Sorry, Thanks ..
How found the http://orafaq.cs.rmit.edu.au/ - Australia and have many examples now... Received on Thu May 01 2003 - 16:09:08 CEST