getting subsets of results

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 - 12:12:53 CST