Finding previous and Next value

Question

Hi,

Please help me to acheive this requirement.

 

Input:

id	Value
1	100
2	200
3	300
4	400
5	500

 

Output:

id	Value	Pre	Nxt
1	100	0	200
2	200	100	300
3	300	200	400
4	400	300	500
5	500	400	0