(B)0reduce-clause =

    qqqqq> REDUCED TO qqqwqq> value-expr qqqqqwqqq>
                         mqqqqqq<qqqq , qq<qqqj

    Lets you eliminate duplicate values for fields in a record
    stream. You can use this expression to eliminate redundancy in
    the results of a query and to group the records in a relation
    according to a field value. Oracle Rdb does not guarantee the
    sorting order of the resulting record stream. To assure the
    desired order use the SORTED BY clause. If you use the REDUCED
    clause, you should retrieve only the fields that you specify in
    the list of value expressions. If you retrieve other fields, the
    results are unpredictable.