PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Albert Ng <albert at ANGIS dot USYD dot EDU dot AU>
Subject: return only a subset of a result
Date: May 21 1998 10:57PM

Hi All,

   I am just wondering is there a way to do the following:

1. do a select statement with order by - which might result in a few thousand rows
2. but instead of returning all rows, I just want to return, say rows 20-30 of the result
    set.
I know I can make a loop to go through the result set but that's slow. So are there
other smarter ways to do it?

Thanks :)
Alb
---------------------------------------------------------------------------
|   ANGIS- The Australian National Genomic Information Service |
|    http://www.angis.su.oz.au      email: albert@angis.su.oz.au   |
|    Phone: 61-2-9351 7219          FAX: 61-2-9351 5694              |
---------------------------------------------------------------------------