学习时间:
2023年2月10日
题目描述:
题解分享:
# 作 者 : 繁 华 倾 夏
# 力扣(LeetCode):626. 换座位
# MySQL 数据库
SELECT
(CASE
WHEN MOD(id, 2) != 0 AND counts != id THEN id + 1
WHEN MOD(id, 2) != 0 AND counts = id THEN id
ELSE id - 1
END) AS id,
student
FROM
seat,
(SELECT
COUNT(*) AS counts
FROM
seat) AS seat_counts
ORDER BY id ASC