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

select a.ord_col, a.other_stf
  from table_name a
 where 15>(select count(*) from table_name b where b.ord_col<a.ord_col)  order by a.ord_col;

Albert FEDIDA 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 - 08:47:30 CDT