SQL question.

From: Roberto Pérez Lita <rperez_at_tissat.es>
Date: Fri, 11 Jun 1999 08:48:12 +0200
Message-ID: <3760B12C.A9D5643B_at_tissat.es>

Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit

Hello,

[Quoted] I wonder if there is a way to select, for instance, the last 10 rows of [Quoted] 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.

--------------A09B2D31850AB63F65F3819D

Content-Type: text/x-vcard; charset=us-ascii;  name="rperez.vcf"

Content-Transfer-Encoding: 7bit
Content-Description: Tarjeta de Roberto Pérez Lita
Content-Disposition: attachment;

 filename="rperez.vcf"

begin:vcard
n:Pérez Lita;Roberto
tel;fax:+ 34 96 393 99 01
tel;work:+ 34 96 393 99 50
x-mozilla-html:FALSE
url:http://www.tissat.es
org:Tissat, S.A.;Bases de datos
version:2.1
email;internet:rperez_at_tissat.es
adr;quoted-printable:;;Edificio Europa=0D=0AAvda. Aragon, 30 - 5=AA planta.;Valencia;;46021;Spain x-mozilla-cpt:;-3840
fn:Roberto Pérez Lita
end:vcard

--------------A09B2D31850AB63F65F3819D--
Received on Fri Jun 11 1999 - 08:48:12 CEST