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