34,594
社区成员
发帖
与我相关
我的任务
分享
select * from A where ID in(2,1,4,3)
order by case id when 2 then 1
when 1 then 2
when 4 then 3
when 3 then 4
end
select *
,CASE ID WHEN 2 THEN 1 WHEN 1 THEN 2 WHEN 4 THEN 3 WHEN 3 THEN 4 END AS Seq
from A where ID in(2,1,4,3)
ORDER BY Seq