SQL 문제 42 - Exchange Seats LeetCode 626

SQL 문제 42 - Exchange Seats LeetCode 626 Exchange Seats 풀이 -- ORACLE SELECT ID , NVL( CASE WHEN MOD(ID, 2) = 1 THEN LEAD(STUDENT,1) OVER(ORDER BY ID) ELSE LAG(STUDENT,1) OVER(ORDER BY ID) END, STUDENT ) STUDENT FROM SEAT; -- MYSQL SELECT ID , IFNULL( CASE WHEN MOD(ID, 2) = 1 THEN LEAD(STUDENT,1) OVER(ORDER BY ID) ELSE LAG(STUDENT,1) OVER(ORDER BY ID) END, STUDENT ) STUDENT FROM SEAT; -- MSSQL SELECT ID , ISNULL( CASE WHEN ID % 2 = 1 THEN LEAD(STUDENT,1) OVER(ORDER BY ID) ELSE LAG(STUDENT,1) OVER(...