Re: Want to get the first n records

_______________________________________________________________ This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. Thank you. _______________________________________________________________ As far as I can tell, (and I'm sure the others will correct me if I'm wrong) the only way to do that in the version you're using is with a cursor in 4gl or esql. If you're using either one of those, check out the FETCH commands. vtnguyen <vtnguyen@home.com> on 05/01/2000 10:38:31 PM Extension: To: informix-list@iiug.org cc: (bcc: Colleen M. Morrow/JonesDay) Subject: Want to get the first n records Hi there, I would like to get only the first 100 records from the result set of the query. How do I do that? (I am using IDS 7.23.). Thanks Tung Nguyen