getting next row's column without going to next row for resultset

I am facing a strange issue. Actually i need to get one column of the
next row of resultset without actually going to the next row. I have
the freedom to modify the select query for this. So now the new
resultset should have all the older records + one record of the next
row.

This is being done because there are over four lack records in the
database i am using and i cannot do a previous operation after i have
come to the next record.

.

Relevant Pages