Re: rows

In <6ctc8d$hg6$1@news.xmission.com> Thuc Nguyen <thucn@email.utcourts.gov> writes: >We have a table with 1 millon rows. How can I unload the last 100,000 rows from that table? I do not want first 900,000 rows. I recalled that discussion from Informix class and did not remember >how it worked. What qualifies the last rows? Proabably easiest to build an index for your qualification and then just use that in the unloading statement. Something like UNLOAD TO "file" SELECT * FROM table WHERE index_col > value If you're using rowids (and not fragmentation) you can use this in your select statement, assuming this meets your "last rows" criteria. -- Bryan Tonnet batonnet@phase4.com.au