newby top 10
From: jess <jesskelpie_at_hotmail.com.au>
Date: Thu, 01 May 2003 23:39:49 +1000
Message-ID: <0l82bvc19td2ie60kg7711h0jiqlfrjotr_at_4ax.com>
[Quoted] 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
etc Received on Thu May 01 2003 - 15:39:49 CEST
Date: Thu, 01 May 2003 23:39:49 +1000
Message-ID: <0l82bvc19td2ie60kg7711h0jiqlfrjotr_at_4ax.com>
[Quoted] 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 Received on Thu May 01 2003 - 15:39:49 CEST