The following programs demonstrate the use of the FIRST clause
    and the SORT clause. These programs sort the employees relation
    in ascending order based on EMPLOYEE_ID. The FIRST 50 statement
    creates a record stream that contains the first 50 records from
    the sorted employees relation. These programs print the employee
    ID and last name of these fifty employee records.
Additional Information:
explode
extract