请教各位:
如何在Oracle中实现定制排序?
比如,要对工单中下阶料的库存仓库进行排序,规则为:同一工单中的下阶料,将其库存仓库进行排序,并要以H和M开头的仓库显示在该工单的前面.SQL如下:
select we.wip_entity_name,
wro.*,
moq.SUBINVENTORY_CODE,
moq.TRANSACTION_QUANTITY
from wip_entities we,
wip_requirement_operations wro,
mtl_onhand_quantitiesmoq
where we.wip_entity_id=wro.wip_entity_id
and we.organization_id=wro.organization_id
and wro.organization_id=moq.ORGANIZATION_ID
and wro.inventory_item_id=moq.INVENTORY_ITEM_ID
and we.organization_id=572
order by we.wip_entity_name
要对以上SQL做如何修改才能实现此功能?
|