To find a column based on a value

Hello Experts,

I have an urgent requirement. Based on a value in a particular column in a table, i have to select the previous column value.

I have tried using select statement with more compliaction which will affect the performance. Is there any user friendly logic to implement this.

Thanks in Advance!!

Moderator Message: Duplicate post, thread locked.

Edited by: Suhas Saha on Mar 5, 2012 3:01 PM