Re: Limit the Number of Rows Returned by Select ?

In article <stqie92teqd5d9_at_corp.supernews.com>,   dont_at_spam.me (Jon Santarelli) wrote:
> 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.

How about if I want rows 50-60 - would I have to say "and rownum < 61, and skip the first 49?

TIA.

--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com



>

> Jon

>




Sent via Deja.com http://www.deja.com/
Before you buy.