SQL语句where id in 排序按in的顺序显示

Access:

select * From 表 Where id in(1,5,3) order by instr(',1,5,3,',','&id&',')

MSSQL:

select * From 表 Where id in(1,5,3) order by charindex(','+rtrim(cast(id as varchar(10)))+',',',1,5,3,')

More...