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;
ORACLE sql 根据in查询里面数据的顺序进行排序
最新推荐文章于 2024-01-30 11:46:31 发布