LeetCode：626. Exchange Seats

关注

原创最新推荐文章于 2026-03-12 00:00:45 发布 1.2k 阅读 AI 写同款· GEO 优化 ›

LiveGBS流媒体平台GB/T28181实战指南：海康NVR物联网卡摄像头注册失败全链路排查与抓包技巧本文详细解析了LiveGBS流媒体平台中海康NVR物联网卡摄像头注册失败的常见问题及解决方案。通过全链路排查与抓包技巧，包括物联网卡配置、多网卡冲突处理、防火墙设置等，帮助用户快速定位并解决GB/T28181协议下的设备注册难题，提升流媒体平台部署效率。阅读详情

链接：
https://leetcode.com/problems/exchange-seats/description/

题目：
Mary is a teacher in a middle school and she has a table seat storing students’ names and their corresponding seat ids.

The column id is continuous increment.
Mary wants to change seats for the adjacent students.
Can you write a SQL query to output the result for Mary?
+———+———+
| id | student |
+———+———+
| 1 | Abbot |
| 2 | Doris |
| 3 | Emerson |
| 4 | Green |
| 5 | Jeames |
+———+———+
For the sample input, the output is:
+———+———+
| id | student |
+———+———+
| 1 | Doris |
| 2 | Abbot |
| 3 | Green |
| 4 | Emerson |
| 5 | Jeames |
+———+———+
Note:
If the number of students is odd, there is no need to change the last one’s seat.

思路：
case的运用，注意最大值如果是奇数的话不用改变位置。

Answer：

select case when id = (select max(id) from seat) and mod(id, 2) = 1 then id
            when id < (select max(id) from seat) and mod(id, 2) = 1 then id + 1
            when mod(id, 2) = 0 then id - 1
            end as id,
            student
from seat
order by
id