Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: First 20 records from a select, after ordering
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
![]() |
![]() |