sql -- 利用order by 排名作弊
时间：2021-07-01 10:21:17
帮助过：4人阅读
* 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 ;
sql -- 利用order by 排名作弊
标签：union des style select 方法 order sele not from
