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