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

How about the easy answer? Upgrade to XPS! It supports First N. In article <66h1l9$pj1@cssun.mathcs.emory.edu>, James_T_Ford@fleet.com says... > > 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 Int >ernet >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 o >ut in the >} > }Spring. >} > }_______________________________________________________ >____ >} > }Clem Akins (aka clem@informix. >com) >} > }Informix Software, Inc (Standard disclaimers ap >ply) >} > }International Technical Support >} > }Last seen: THE Natural History Museum, London--all day! > >} > } >} > } >} >} Helmut Leininger >} >} Bull AG >} Unix Support >}