Re: Missing feature in informix?

Gnana1 wrote: > > Informix does have this feature. > > select * from tablea where rowid > 10 and rowid < 20.> > Ravi. Nope, 1) This will only give you rows with rowid 10 - 20. This does not limit the result (set of rows returned.) to 10 rows. 2) If you use 7.x or above, it is recommended not to use Rowid and to rewrite any code which does. If you frag your data, rowid is no longer valid. -Mikey