534      阿里云  技术社区[云栖]

ORACLE sql 根据in查询里面数据的顺序进行排序

select rownum||'' as id,t.materialname as prodCode,t.ename as prodName,t.materialtype||'_'||t.groupcode as kindName,
t.unit as unit,'' as spec,'' as price,t.materialcode as remark  
from material_master t where  t.materialcode in ('101010006','101010007','101010009','101010020','101010024','101010025') 
order by case t.materialcode 
when '101010006' then 1 
when '101010007' then 2 
when '101010009' then 3 
when '101010020' then 4 
when '101010024' then 5 
when '101010025'  end;

最后更新：2017-04-03 12:55:02

  上一篇： 并发编程（二）：分析Boost对 互斥量和条件变量的封装及实现生产者消费者问题

  下一篇： ls -l文件类型