Re: First 20 records from a select, after ordering

From: -=< a q u a b u b b l e >=- <aquabubble_at_Remove.No.Parma.Ham.Remove.geocities.com>
Date: Mon, 1 Nov 1999 19:14:32 -0000
Message-ID: <7vkoqs$4e1$1@news4.svr.pol.co.uk>

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:u3cdOALAZ3x98iGHlQ1R5HQcymse_at_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...

Yes, this appears to be the case. On earlier versions, I get the error 'right parenthesis not found'.

I post to this group from home, away from documentation and an Oracle box, so I just answer what I believe to be the case.

Sorry! Received on Mon Nov 01 1999 - 13:14:32 CST