Re: selecting the last 10 rows...

From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 29 Nov 1998 00:28:46 GMT
Message-ID: <73q4fu$83a$1@relay1.dsccc.com>

If the table is truly ordered

select whatever
from where_ever
where rownum < 11
order by ordered_column descending

Martin Trzaskalik (martin_at_ernie.mi.uni-koeln.de) wrote:
: ROWNUM offers a nice feature to select the first 10 rows from a
: ordered table.

: Is there an easy way of selecting the last 10 rows from a ordered
: table?

: Martin

--
While Alcatel may claim ownership of all my ideas (on or off the job), Alcatel does not claim any responsibility for them. Warranty expired when u opened this article and I will not be responsible for its contents or use. Received on Sat Nov 28 1998 - 18:28:46 CST