LAG, LEAD

LAG and LEAD

Use LAG and LEAD to get values from previous/next rows.

SELECT employee_id, hire_date,
       LAG(hire_date) OVER (ORDER BY hire_date) AS prev_hire,
       LEAD(hire_date) OVER (ORDER BY hire_date) AS next_hire
FROM employees;