--多优先级排序, 先根据controlID倒叙排列,再根据lotName正序排列
select L.LOTNAME ,L.CONTROLID
from LOT L , CONTROLIDDEFINITION C
where L.FACTORYNAME = 'FAB'
AND L.CONTROLID = C.CONTROLID
order by C.CONTROLID DESC,L.LOTNAME
SQL优先排序问题
最新推荐文章于 2023-09-04 16:00:16 发布