Re: simple SQL question

[Quoted] 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 CEST