Re: Re[2]: SQL: How to select first N rows?

hi, 1. create a temp table. 2. do an insert select from that source table into this temp table. 3. Whenever u create a temp table & do an insert select the rows inserted would have rowid from 1 onwards serially. So just do a select from this temp tabel where rowid < N . Not an effiecient way. But this worked for me. Rajesh At 01:42 PM 11/24/97 -0500, James T Ford wrote: } or on xps already available.... } } } }______________________________ Reply Separator _________________________________ }Subject: Re: SQL: How to select first N rows? }Author: Clem Akins <clem@informix.com> at Internet }Date: 11/24/97 7:23 AM } } }Cosmo asks: }>Is there a way to select the first N rows from a table? } }Issue the command to Informix Dynamic Server 7.3, due out in the }Spring. }___________________________________________________________ }Clem Akins (aka clem@informix.com) }Informix Software, Inc (Standard disclaimers apply) }International Technical Support }Last seen: THE Natural History Museum, London--all day! } }