GitHub

WINDOWS_FUNCTION(LAG,LEAD,ROW_NUMBER).sql

SELECT e.*, LAG(salary) over(partition by dept_name ORDER BY emp_id) AS Pre_Employee_Sal, LEAD(salary) over(partition by dept_name ORDER BY emp_id) AS Next_Employee ...