Bill,
I'm sure somebody else will have something more specific than this for your
needs, but let me give it a shot with the Syntax of the DBMS I use all the
time (Which, also does not have a limit keyword). Do you have a TOP keyword?
If so, you can probably do something like:
SELECT TOP 10 Column
FROM DB..Table
WHERE Column NOT IN
(SELECT TOP 20 Column
FROM DB..Table
ORDER BY Column)
ORDER BY Column
That would give you records #21-30 of the full result set (If you have a TOP
keyword).
Hopefully something like this will help.
Steve Howard
-----Original Message-----
From: Bill OConnor [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 4:48 PM
To: [EMAIL PROTECTED]
Subject: Limiting the number of records selected.
I can do this easily with MySQL but doing it with
Oracle has not been that obvious to me. I want to use
a subset of the selected rows on a webpage. For
instance if the query returns 100 rows I want show
just 10 of them on the page, 11-20 on the next etc.
Is it possible to specify the range of rows returned
from the select as part of the select statement?
I think I said that right.
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
