SELECT COL1, LEAD(COL1) OVER (ORDER BY COL1) AS COL2 FROM T ORDER BY COL1;
SELECT COL1, LAG(COL1, 1, 0) OVER (ORDER BY COL1) AS COL2 FROM T ORDER BY COL1;
SELECT COL1, LAG(COL1, 2) OVER (ORDER BY COL1) AS COL2 FROM T ORDER BY COL1;
SELECT COL1, LAG(COL1) OVER (ORDER BY COL1) AS COL2 FROM T ORDER BY COL1;
나만의 풀이, 암기법을 나눠 보세요. 정답이 포함될 수 있어요.