MySQL的case条件语句

最新推荐文章于 2024-06-23 17:08:46 发布

洁娃

最新推荐文章于 2024-06-23 17:08:46 发布

阅读量458

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/fffffffff128/article/details/89314142

版权

MySQL 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

626.换座位

代码来源（力扣评论）

SELECT (CASE 
            WHEN MOD(id,2) = 1 AND id = (SELECT COUNT(*) FROM seat) THEN id
            WHEN MOD(id,2) = 1 THEN id+1
            ElSE id-1
        END) AS id, student
FROM seat
ORDER BY id;

查询表seat记录的行数

SELECT COUNT(*) FROM seat

我自己的思路

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