Re: How to limit number of rows SELECTed?

Posted in 1997

HARINATH S VENKATA — 11 Jun 1997 14:18:27 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi, I am bit new to the list. Anyhow, This would better solve your Purpose. SELECT * from SC1_TABLE SC1 where 20 > (SELECT count(*) FROM syscolumns SC2_TABLE SC2 WHERE sc1.rowid > sc2.rowid) HARINATH VENKATA PSI DATA SYSTEMS Ltd. Phoenix