predicate One of the following predicates: ALL, DISTINCT, DISTINCTROW, or TOP. Use the predicate to restrict the number of records returned. If none is specified, the default is ALL. * Specifies that ...