Page 1 of 1

processing rows

Posted: Fri Dec 14, 2007 1:54 pm
by just4u_sharath
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.

Posted: Mon Dec 17, 2007 7:16 am
by keshav0307
write user defined query for not selecting the 1st and last row in the table

Posted: Mon Dec 17, 2007 1:49 pm
by ray.wurlod
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.