34,593
社区成员
发帖
与我相关
我的任务
分享
create table tb
(
id int,
name varchar(10)
)
insert into tb values(1,'AA')
insert into tb values(2,'BB')
insert into tb values(3,'CC')
insert into tb values(4,'DD')
insert into tb values(5,'EE')
select * from tb order by case when id=1 then 0 else 1 end,id desc
/*
id,name
1,AA
5,EE
4,DD
3,CC
2,BB
(5 行受影响)
or
order by 1-SIGN(ID-1)asc,ID desc