都图文并貌了还不够具体?!?!倒序显示 我想要的结果 5 EE 1 AA 4 DD 5 EE 3 CC 4 DD 2 BB 3 CC 1 AA 2 BB
or order by 1-SIGN(ID-1)asc,ID desc
+1 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 行受影响)
朋友在看看哪写错没 select * from users order by id desc case when ID=1 then 0 else 1 end,ID desc 消息 156,级别 15,状态 1,第 1 行 关键字 'case' 附近有语法错误。
5 EE 1 AA
4 DD 5 EE
3 CC 4 DD
2 BB 3 CC
1 AA 2 BB
or
order by 1-SIGN(ID-1)asc,ID desc
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 行受影响)
select * from users order by id desc case when ID=1 then 0 else 1 end,ID desc
消息 156,级别 15,状态 1,第 1 行
关键字 'case' 附近有语法错误。