本文提供了一个MySQL查询示例，展示了如何通过使用自定义变量和联合查询来重新排列学生座位，确保输出结果按照特定规则进行排序。
# Write your MySQL query statement below
select @rank:=@rank+1 as id,student from
( select *
from
(
(select (id-1) as id,student from seat where id%2=0)
union all
(select (id+1) as id,student from seat where id%2!=0)
) t order by id asc
select @rank:=@rank+1 as id,student from
( select *
from
(
(select (id-1) as id,student from seat where id%2=0)
union all
(select (id+1) as id,student from seat where id%2!=0)
) t order by id asc
) res,(select @rank:=0) p
看完的朋友招个手点个赞，不然我真的感觉优快云是个单机游戏
扫一扫
460
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
