检索最新的行-Oracle 12c之前的版本

对于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