[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
Sent: Tuesday, July 08, 2008 1:09 PM
Subject: RE: SQL and retrieving the next xx rows
Take a look at the FETCH FIRST clause of the select statement. I think
that might be what you are looking for. IIRC there is also a FETCH NEXT
but it requires a cursor.
select.... where ordernum >= searchorder fetch first 100 rows only
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bradley V. Stone
Sent: Tuesday, July 08, 2008 11:00 AM
Subject: SQL and retrieving the next xx rows
When running an SQL statement on say, and order file, lets say you were
letting the user enter an order number to search by used in the SQL
Select..... where ordernum = searchorder
Now, lets say that you wanted to also select the next 100 orders after
the order number entered. The problem being that the order numbers are
So we could have:
So we'd want to say:
select.... where ordernum >= searchorder
but only have it select the next 100 orders (mainly because if we
didn't, the search would take forever if there were a bazillion orders
in the database).
I have seen reference to a LIMIT keyword, but it didn't seem to like it
in the SQL interface.
Bradley V. Stone
BVSTools - www.bvstools.com
eRPG SDK - www.erpgsdk.com
Privileged and Confidential. This e-mail, and any attachments
there to, is intended only for use by the addressee(s) named
herein and may contain privileged or confidential information.
If you have received this e-mail in error, please notify me
immediately by a return e-mail and delete this e-mail. You are
hereby notified that any dissemination, distribution or copying
of this e-mail and/or any attachments thereto, is strictly prohibited.
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact