Re: getting subsets of results

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Tue, 14 Nov 2000 14:05:48 -0500
Message-ID: <8us285$lkc$1@bob.news.rcn.net>

This sounds like a job for PL/SQL!

If you don't know PL/SQL and can't wait to go buy the book, hop on over to www.free-ed.net and click on their IT Course Catalog link and then the one for Oracle and then the one for PL/SQL.

<tommychill_at_my-deja.com> wrote in message news:8urvat$cq2$1_at_nnrp1.deja.com...
> I need to return a subset of rows from a table but I have a twist.
>
> Say I have 100 rows. I want to show them 10 at a time.
>
> I can use ROWNUM to show the first 10 rows, but does anyone have a good
> way of showing the next 10 (11 - 20)?
>
> You can't use ROWNUM with a greater than operator bc it always returns
> false.
>
> Please help...
>
> thanx...
>
> t
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 14 2000 - 13:05:48 CST