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文件類型