LEAD
The LEAD and LAG functions in SQL Server 2012
The LEAD function provides value from the next row in result of query.
The LAG function provides value from the previous row ... BY p.name ORDER BY s.value) as prev,
p.name, s.year, s.value
FROM person p
JOIN salary s on s.id_person_fk = p.id ;