Re: SQL Question
From: martijn <mlinsen_at_vx8000.nl>
Date: 2000/07/18
Message-ID: <3973ec07.0_at_gaspra.oss.akzonobel.nl>#1/1
Date: 2000/07/18
Message-ID: <3973ec07.0_at_gaspra.oss.akzonobel.nl>#1/1
[Quoted] The where rownum < 11 is executed BEFORE the order by clause (In Oracle 7x)
Herbert Fukerider wrote in message <39732AF4.3A25F182_at_rfn.de>...
Why not
select id, count from table_name where rownum < 11 order by 2 desc;
H.Fukerider
Received on Tue Jul 18 2000 - 00:00:00 CEST