Re: How to limit rows selected?

Posted in 1997

HARINATH S VENKATA — 3 Jul 1997 17:28:24 -0400 — source: Informix-list mailing list archive (1991-1998)

I had replied to this query recently. Anyhow, try this SELECT * from TABLE1 SC1 where <No.of rows you require> > (SELECT count(*) FROM TABLE1 SC2 WHERE sc1.rowid > sc2.rowid) I hope this should solve your purpose. HARINATH VENKATA NEW YORK