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

is this a synonym for greasy??? anyhow - for this problem select rows into a temp table with a serial column select from temp where serial < # ______________________________ Reply Separator _________________________________ Subject: RE: SQL: How to select first N rows? Author: "Miguel Cerda Ayala" <mergas@entelchile.net> at Internet Date: 12/5/97 10:07 AM Are you creasy???!!!!! ---------- } De: Helmut Leininger <Helmut.Leininger@bull> } A: informix-list@rmy.emory.edu } Asunto: Re: SQL: How to select first N rows? } Fecha: Friday 5 de December de 1997 03:40 } } } } Rajesh Ravindran wrote: } } > 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. } } Not true. It may work for SE. But with Online the rowid's may be arbitrary } and surely do not start with 1. } } > So just do a select from this temp tabel where rowid < N . } > } > Not an effiecient way. But this worked for me. } > } > Rajesh } > } > }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! } > } } > } } } Helmut Leininger } } Bull AG } Unix Support }