LEAD

1
SELECT date, price,
2
  LEAD(price) OVER (ORDER BY date) AS next_price
3
FROM stock_prices;

1
SELECT event_time, event_type,
2
  TIMESTAMPDIFF(SECOND, event_time, 
3
    LEAD(event_time) OVER (ORDER BY event_time)
4
  ) AS seconds_to_next
5
FROM user_events;

1
SELECT task, due_date,
2
  CASE WHEN LEAD(due_date) OVER (ORDER BY due_date) 
3
       = DATE_ADD(due_date, INTERVAL 1 DAY)
4
  THEN 'Back-to-back!'
5
  ELSE 'OK'
6
  END AS alert
7
FROM tasks;