17,377
社区成员
发帖
与我相关
我的任务
分享
//
select name
from A
where id in (11,1,2,9,5,6,7)
order by decode(id,
11,1,
1,2,
2,3,
9,4,
5,5,
6,6,
7,7);
select * from A
order by charindex(','+ltrim(id)+',',',11,1,2,9,5,6,7,')
order by charindex(','+ltrim(ID)+',',',11,1,2,9,5,6,7,')