对于Oracle DB 12c之前的版本，这应该可以
SELECT * FROM
(
SELECT ORDER_TYPE,
ORDER_NUMBER,
ORDER_LINE,
NOTE_PAD.CREATED_DATE
FROM ORDER_AWB INNER JOIN
NOTE_PAD ON ( "ORDER_AWB"."NOTES" = "NOTE_PAD"."NOTES" )
WHERE ( "ORDER_AWB"."ORDER_NUMBER" = '867318' )
ORDER BY NOTE_PAD.CREATED_DATE DESC
)
WHERE ROWNUM <= 1
602392714
清零编程群