2011年7月2日
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,')MySQL:select * From 表 Where id in (1,5,3) order by instr( 阅读全文
posted @ 2011-07-02 11:15 Jela 阅读(925) 评论(0) 推荐(0)