Re: Limit the Number of Rows Returned by Select ?

stevechol_at_freeuk.com (Steve Cholerton) wrote in <udaptso0tj6nafjfjn5npumktigsbdhqaj_at_4ax.com>:

>Hi all, can anybody advise if there is a way to limit the number of
>rows returned by a select
>

select * from table
where attribute = something
and rownum < 11;

Will give you the first 10 rows. You may need or want to do an order by or something else to get the rows that you actually want.

Jon Received on Thu Oct 05 2000 - 22:40:57 CDT