ORACLE子查询有order by 报缺失右括号

[ajdkjalj]

select PM_MODEL_CODE,(select WD_IN_TIME from T_WIP_DETAIL where WD_MODEL_CODE=m.PM_MODEL_CODE and ROWNUM=1 order by WD_IN_TIME) WD_IN_TIME
 from T_PM_MO_BASE m group by PM_MODEL_CODE

括号里我又必须按时间排序，然后取第一个，求解决方法

[学海无涯-回头是岸]

应该 在 order by的 外层 取rownum，不然没有作用

[wildwolv]

T_WIP_DETAIL里面有WD_MODEL_CODE，为什么要还要从T_PM_MO_BASE里面取PM_MODEL_CODE？ 为什么要写group by？

[超叔csdn]

select PM_MODEL_CODE,WD_IN_TIME
from (
select m.PM_MODEL_CODE,n.WD_IN_TIME ,row_number()over(partition by m.PM_MODEL_CODE order by WD_IN_TIME) rn
from T_PM_MO_BASE m left join T_WIP_DETAIL n on m.PM_MODEL_CODE=n.WD_MODEL_CODE)
where rn=1