RDO> FOR E IN EMPLOYEES SORTED BY E.BIRTHDAY Because this example did not specify the sort order, Oracle Rdb automatically sorts the EMPLOYEES records in ASCENDING order by BIRTHDAY. FOR E IN EMPLOYEES SORTED BY DESCENDING E.STATUS_CODE, ASCENDING E.LAST_NAME, E.SOCIAL_SECURITY If you do not specify ASCENDING or DESCENDING for the second or subsequent sort keys, Oracle Rdb uses the order you specified for the preceding sort key.