sql — 利用order by 排名作弊

云博小周宇2024年5月5日2023年8月20日1 Min Read

表结构:

需求:

方法1:union

select * from (select *  from user_level where id in (2,4,6) order by user_total desc ) a
union
(select * from (select *  from user_level where id not in (2,4,6) order by user_total desc ) b)

方法2:直接在order by加

select * from user_level order by id in (2,4,6) desc,user_total desc ;