SQL code: select id,title from T_QuestionInfo where id in(912,1,899,836,861,556,808,911,859,883) 这样查出来是1,556,808,836,859,861,883,899,911,912 这样是按id的升序排序的 我想让他按查询的in(912,1,899,836,861,556,808,911,859,883)排序 请问这样排序呢???
引用 SQL codeselect id,titlefrom T_QuestionInfowhere idin(912,1,899,836,861,556,808,911,859,883)orderbycharindex(','+ltrim(id)+',',',912,1,899,836,861,556,808,911,859,883,') good 谢谢啦。 百年树人真利害, 好强的贴子, 引用 SQL codeselect id,titlefrom T_QuestionInfowhere idin(912,1,899,836,861,556,808,911,859,883)orderbycharindex(','+ltrim(id)+',',',912,1,899,836,861,556,808,911,859,883,') UP引用 SQL codeselect id,titlefrom T_QuestionInfowhere idin(912,1,899,836,861,556,808,911,859,883)orderbycharindex(','+ltrim(id)+',',',912,1,899,836,861,556,808,911,859,883,') up
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'亿' select cast(convert(numeric(18,2),1275674000000/100000000)as real) 为什么上一个用varchar转换后就只保留了� ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 上面一个简单的SQL,执行时间2.6� ......