Re: Restrict the number of records

G. Kakisina wrote:

> Hi,
>
> I want to know if it is possible to restrict the number of records to show
> when using a SELECT statement.
> For example, i got a table with a thousand records. When I use a SELECT
> statement, 500 records show up. I only want 10 results. How can i do this?
>
> G. K.

Why not try to use rownum ??

select * from table1 where rownum <= 100 ;

John Koo Received on Tue Jan 05 1999 - 05:23:57 CST