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: First 20 records from a select, after ordering

Re: First 20 records from a select, after ordering

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 01 Nov 1999 06:22:23 -0500
Message-ID: <u3cdOALAZ3x98iGHlQ1R5HQcymse@4ax.com>


A copy of this was sent to "-=< a q u a b u b b l e >=-" <aquabubble_at_Remove.No.Parma.Ham.Remove.geocities.com> (if that email address didn't require changing) On Sun, 31 Oct 1999 20:21:46 -0000, you wrote:

[snip]

>> >
>> > SELECT *
>> > FROM (SELECT <columns>
>> > FROM <tablename>
>> > ORDER BY <column>)
>> > WHERE rownum < 21
>> >
>> > This would do your job. HTH

>>
>> I thought this was only available in 8i, not 8....
>>
>I don't see why it wouldn't work in earlier versions than that.
>

Order by in a subquery or view was not supported prior to Oracle8i, release 8.1...

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Nov 01 1999 - 05:22:23 CST

Original text of this message

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