Re: Limit rowcount

Posted in 2000

Obnoxio The Clown — Thu, 28 Sep 2000 11:14:57 BST — source: Informix-list mailing list archive (1991-1998)

From: Ron Singh <ron@ezenet.com> > >Appreciate if anyone could let me know how to limit the number of rows >in Informix. In Oracle select * from table where rownum < 10 would give >9 rows. SELECT FIRST 9 * FROM table..._________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.