Re: How to get the first 15 records of an Oracle query ?

select * from table
where rownum <=15;

Good luck,

Nuno Guerreiro

On Wed, 23 Sep 1998 15:09:01 +0200, "Albert FEDIDA" <afedida_at_club-internet.fr> wrote:

>I wonder if it is possible in SQL Oracle to get the first 15 records
>for a query?
>With MS-Access, it's as simple as :
>
>SELECT TOP 15 FROM TABLE;
>
>Thanks for your help.
>
>Albert
>
>
Received on Wed Sep 23 1998 - 10:35:09 CDT