How to select first 50 rows?

Posted in 2003

miyaki — Tue, 28 Oct 2003 17:51:57 -0800 (PST) — source: Usenet: comp.databases.informix

Hi guys, If i have a total 500 rows of records set, but i need to return 50 rows at one time by a sql statement. Do you know how to do that? Thanks in advance. Miyaki __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ sending to informix-list

↪ replying to miyaki

dusong — Tue, 28 Oct 2003 23:55:02 -0500 — source: Usenet: comp.databases.informix

select first xx_rows * from table -- Posted via http://dbforums.com