How to take the next value after a certain one in a select?

Question

SQL

How to take the next value from the select, but bind it to the current one?

Answer 1

Use the LEAD function:

select 
  id,
  Month,
  LEAD(Month) OVER (ORDER BY Id) NextMonth
from Months;

MS SQL Fiddle