LEAD AND LAG FUNCTION

--- USING THE LEAD AND LAG FUNCTION
--- LAG SHOWS PREVIOUS ROW, LEAD SHOWS NEXT ROWS

select * from stmenu order by parentid

select menuitem,lag(menuitem) over(order by menuitem) previousItm,
lead(menuitem) over(order by menuitem) nextItm
from stmenu