(B)0first-clause =

    qqqqqq>  FIRST  qqqq>  value-expr  qqqqqq>

    Specifies how many records are in the record stream formed by
    the record selection expression. If you include the element FIRST
    n, the record stream has no more than n records. The argument n
    should be a positive integer or a value expression that evaluates
    to a positive integer. For more information on value expressions,
    ask for HELP on Value_expr.

1  –  More

    Note the following rules:

    o  Oracle Rdb does not guarantee the order of records in a record
       stream unless you specify a sort order. For this reason, when
       you use FIRST n in the RSE, the actual records in the record
       stream are unpredictable. Therefore, you should always specify
       SORT when you use FIRST n.

    o  If n evaluates to zero or a negative number, the record stream
       will be empty.

    o  If you specify FIRST n and n is greater than the number
       of records satisfying those conditions, the record stream
       consists of all records meeting the conditions of the record
       selection expression.

    o  If n is not an integer, Oracle Rdb rounds any fractional part
       of the value and uses the remaining integer as the number of
       records in the record stream.