Re: Limiting Rows Returned in Query

Alvin Sylvain wrote:

> I want to be able to limit the number of rows returned in a query
> statement. I seem to recall something such as:
>
> select columna, columnb
> from tablea
> where 1=1
> and columnc > value
> and maxrows <= 100; <<<<<<<<<<<<<<<<

  SELECT columna, columnb FROM tablea WHERE columnc > value and rownum <= 100;

  Related Topics: SGA, SQL

-- 
Name        : Lun Wing San
Title       : Senior Consultant of Lun's Oracle Solution Company
              System Administrator and Oracle DBA of the Quick Response Center
              Oracle Developer of the Hong Kong Productivity Council
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841