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

"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
>
>

Depends on what you mean by the 'first' 15 records...Oracle stores data in an arbitrary order so the rows retrieved absent some qualifier ( where... or Order by ) will be 'random' - to get 'only' ( not necessarily 'first' ) 15 records use where rownum < 16 ;

To reply please remove the 'nospam' part of the address Received on Wed Sep 23 1998 - 09:52:23 CDT