Re: simple SQL question

From: Martin Douglas <Martin.Douglas_at_Boeing.com>
Date: 1999/08/04
Message-ID: <37A84570.D21838B4@Boeing.com>#1/1

Alternatively, you could add a column that stores an integer from a sequence and then select from the table ordering by the seq_col in descending fashion and add a where clause requesting rownum <= 10.

Best Regards,

-Martin-

kev wrote:
>
> Hi,
>
> Just wondering - what's the best way to retrieve, say, the latest ten
> entries to a table.
> Does Oracle have a MAXROWS func (I couldn't find one in the docs)
>
> Thanks,
>
> - Kev
Received on Wed Aug 04 1999 - 00:00:00 CDT