38. Exchange Seat | SQL Interview Questions and Answers

[@LifeLogic-Insights]

another way you can solve this question by using ROW NO FUNCTION SELECT ROW_NUMBER() OVER(order by IF(MOD(id, 2) = 0, id-1, id+1) ) as id, student FROM seat;