How Can i retrieve previous record of last record i.e one earlier than last record for a particular code..:

Hi and welcome to the forum :)

Couldn't you just save the value in another variable? Can you please elaborate?

If you have a code already, please post it.

I think you are talking about the second last record of the table. If that is true then you can do it using following code -

select tiitm001.item
from tiitm001
where <Condition>
as set with 2 rows
order by tiitm001._index1 desc