[Mysql] 위/아래 ROW 값 가져오기 (LAG, LEAD)

■ Mysql 위/아래 ROW 값 가져오기 (LAG, LEAD)

SELECT  
	column_1
	, column_2
	, IFNULL(LAG(column_1) OVER (ORDER BY column_1), '') AS 이전행column_1
	, IFNULL(LAG(column_2) OVER (ORDER BY column_1), '') AS 이전행column_2
	, IFNULL(LEAD(column_1) OVER (ORDER BY column_1), '') AS 다음행column_1
	, IFNULL(LEAD(column_2) OVER (ORDER BY column_1), '') AS 다음행column_2
FROM table_name
ORDER BY column_1