Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL Question.

SQL Question.

From: Roberto Pérez Lita <rperez_at_tissat.es>
Date: Fri, 11 Jun 1999 08:45:51 +0200
Message-ID: <3760B09F.CB1DE231@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;

Thanks in advance.
Roberto Pérez Lita.


Received on Fri Jun 11 1999 - 01:45:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US