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

Albert -

    there is another way:-

    SELECT * FROM table WHERE ROWNUM < 16;

    rgds,john

Albert FEDIDA wrote in message <6uarve$pdl$2_at_front3.grolier.fr>...
>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 - 09:23:47 CDT