Re: rows

Or try reverse ordering the rows and outputing only the first 100,000. Providing you have an index. How do you plan to qualify that the rows are the last? Jason On Tue, 24 Feb 1998 12:02:18 -0600, Sujit.Pal@alltel.com wrote: > > Thuc > > Perhaps this is really obvious and you have considered it already, but > how about writing a 4GL or ESQL/C program that skips the first 900,000 > rows and outputs only the last 100,000? > > Sujit > > >______________________________ Reply Separator _________________________________ >Subject: rows >Author: Thuc Nguyen <thucn@email.utcourts.gov> at Internet >Date: 2/23/98 7:07 PM > > >Hi >I am running online 5.03 on HP9000 > >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. > >thanks >thuc >