processing rows

just4u_sharath · Post by **just4u_sharath** » Fri Dec 14, 2007 1:54 pm

I have some number of rows. I dont know how many rows i will get from the table. But on the available data i should make some changes leaving the first and last record. I should transform the data which is between the 1st row and last row. How can i accomplish this.

keshav0307 · Post by **keshav0307** » Mon Dec 17, 2007 7:16 am

write user defined query for not selecting the 1st and last row in the table

ray.wurlod · Post by **ray.wurlod** » Mon Dec 17, 2007 1:49 pm

What precisely do you mean by "first" and "last" in this context? The order in which rows are stored in database tables is under control of the database engine, not of the user, and therefore the terms "first" and "last" don't really have any meaning.