Re: SQL Question

From: Eugenio <Eugenio.Spadafora_at_Compaq.Com>
Date: 2000/07/19
Message-ID: <8l3h48$a7u$1_at_mailint03.im.hou.compaq.com>#1/1


and in Oracle 8.x, but you can use it in subqueries

--
Ciao

Eugenio
remove _nospam from reply address

Opinions are mine and do not necessarily reflect those of my company

=======================================================
martijn wrote in message <3973ec07.0_at_gaspra.oss.akzonobel.nl>...

>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 Wed Jul 19 2000 - 00:00:00 CEST

Original text of this message