Re: Top 20 records in a table ??
From: Matthias Kleinicke <extern.matthias.kleinicke_at_volkswagen.de>
Date: Tue, 11 Jan 2000 10:19:57 +0100
Message-ID: <85esju$9so2_at_doiftp1.volkswagen.de>
Date: Tue, 11 Jan 2000 10:19:57 +0100
Message-ID: <85esju$9so2_at_doiftp1.volkswagen.de>
Hello,
[Quoted] 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 [Quoted] BY will be done later on, so there are selected 20 rows randomly. this are sorted, but not the first 20. Received on Tue Jan 11 2000 - 10:19:57 CET