简单sql问题，给分50

[kavi]

select id ,name from user where id in(1,3,2,4)
sqlserver 查询结果默认按id asc 排序了
我想不按照它默认排序且就按照我给的id顺序排序（1324）该怎么写？
标准sql的写法其他数据库也的适应

[让你望见影子的墙]

select id ,name from user where id in(1,3,2,4)
order by charindex( ltrim(id) ,'1,3,2,4')

[开着拖拉机泡妞]

select id ，name from user where id in(1,3,2,4)  order by case when 1 then 1 when 3 then 2 when 2 then 3 when 4 then 4 end
--try

[汤姆克鲁斯]

前后都加引号
避免1 12 这种。

select id ,name from user where id in(1,3,2,4)   
order by charindex( ','+ltrim(id)+',' ,',1,3,2,4,')

[开着拖拉机泡妞]

select name,number from master..spt_values  where number in(1,2,3,4) and type='p'
order by case when number=1 then 1 
when number=3 then 2 when number=2 then 3 when number=4 then 4 end

/*
name                                number
----------------------------------- -----------
NULL                                1
NULL                                3
NULL                                2
NULL                                4

(4 行受影响)
*/

[骑着蜗牛去爬山]

select id ,name from user where id in(1,3,2,4) order by (id+1)%2,id

[叶子]

select
   id ,name 
from [user] where id in(1,3,2,4)   
order by charindex( ','+ltrim(id)+',' ,',1,3,2,4,')

[以学习为目的]

SELECT   id,
         name
FROM     [user]
WHERE    id IN (1,
                3,
                2,
                4)
ORDER BY Charindex(',' + Ltrim(id) + ',',',1,3,2,4,')