Re: Query regarding SQL Query - Limiting Result Set

Hello Paus,

> You can write the following query:
>
> SELECT * FROM
> (select * from TABLE_NAME
> WHERE NAME = 'someperson'
> ORDER BY RECORD_DATE desc)
> where rownum<=5;

I think, this work's only with oracle 8i Received on Sat Mar 18 2000 - 09:33:05 CST