Re: SQL question.
From: Valery Yourinsky <vsu_at_softexpress.ru>
Date: Wed, 16 Jun 1999 16:11:46 +0300
Message-ID: <37679402_at_mail.softservice.ru>
In general (with joins e.t.c.) it is not the first 10 rows! It is arbitrary 10 rows!
Date: Wed, 16 Jun 1999 16:11:46 +0300
Message-ID: <37679402_at_mail.softservice.ru>
>Roberto Pérez Lita <rperez_at_tissat.es> wrote in message
>news:3760B12C.A9D5643B_at_tissat.es...
>> Hello,
>>
>> I wonder if there is a way to select, for instance, the last 10 rows of
>> a table. I know that i can select the first 10 rows by:
>>
>> SELECT *
>> FROM CUSTOMERS
>> WHERE ROWNUM<=10;
^^^^^^^^^^^^^^^
In general (with joins e.t.c.) it is not the first 10 rows! It is arbitrary 10 rows!
Valery Yourinsky
--- [Quoted] Softservice, Moscow ORACLE PARTNER tel/fax (095) 333-63-10, 128-18-21 http://www.softexpress.ru ICQ# 368 97 94 second E-mail: vsur_at_usa.netReceived on Wed Jun 16 1999 - 15:11:46 CEST