Re: Display last records in a table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 25 May 2001 18:26:44 +0200
Message-ID: <tgt1q3cclr1hd3@beta-news.demon.nl>

"Thomas Stuefer" <stuefer_at_halli-data.at> wrote in message news:5luP6.5$NU2.161908_at_news.salzburg-online.at...
> How can i display the last records in a table with an select-statement ?
>
> For example:
>
> I have an table with many thousand of records and only want to display the
> last 10 added records.
>
> Many thanks for your help !
>
> Tom
>
>
>

If you don't have a timestamp in your record, this is not possible. Records are inserted physically at random, there's no guarantee at all they will be at the physical end of the table.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri May 25 2001 - 11:26:44 CDT