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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results