select po.po_no,
(select td_rpoc.etd from td_rpoc where td_rpoc.po_no=po.po_no and rownum < 2 order by td_rpoc.create_date desc)as etd
from td_po po报出缺少右括号?那位能帮我看下,万分感谢!!
(select td_rpoc.etd from td_rpoc where td_rpoc.po_no=po.po_no and rownum < 2 order by td_rpoc.create_date desc)as etd
from td_po po报出缺少右括号?那位能帮我看下,万分感谢!!
select po.po_no, t.etd
from td_po po, (select td_rpoc.etd from td_rpoc where td_rpoc.po_no=po.po_no and rownum < 2 order by td_rpoc.create_date desc) t
from td_po po, (select po_no ,etd , row_number() over ( partition by td_rpoc.etd order by td_rpoc.create_date desc ) rank from td_rpoc ) t
where po.po_no=t.po_no and t.rank=1