Re: Top 20 records in a table ??
From: Wans <md1997_at_wans.net>
Date: Tue, 11 Jan 2000 20:56:50 -0600
Message-ID: <387bee45_at_netmonnt.wans.net>
Date: Tue, 11 Jan 2000 20:56:50 -0600
Message-ID: <387bee45_at_netmonnt.wans.net>
"Matthias Kleinicke" <extern.matthias.kleinicke_at_volkswagen.de> wrote in
message news:85esju$9so2_at_doiftp1.volkswagen.de...
> Hello,
>
> Lindsay Walker <lindsay.walker_at_portfolio.co.uk> schrieb in im Newsbeitrag:
> 947500462.2120.0.nnrp-14.c1c33102_at_news.demon.co.uk...
> > SELECT pay
> > FROM emp
> > WHERE rownum < 21
> > ORDER BY pay DESC
>
> This will NOT do it.
>
> ROWNUM is evaluated while selecting the set. most time the sorting for
ORDER
> BY will be done later on, so there are selected 20 rows randomly. this are
> sorted, but not the first 20.
>
>
>
Received on Wed Jan 12 2000 - 03:56:50 CET