RECORDS SQL Function
Limits the number of records returned in the result set.
Lower-boundary and upper-boundary are both required and must both evaluate to a positive integer. Upper-boundary must be higher than lower-boundary.
If RECORDS is combined with ORDER BY, first the entire result set is built as specified by ORDER BY. Then, a subset of that ordered list is returned as specified by RECORDS.
This example returns a set of 20 records from the employee table.
This example returns records 3, 4 and 5 from the person table after records have been sorted by family name:
This example shows that arguments of RECORDS may alternatively be passed as host variables:
RECORDS is a convertible function resolved by USoft and thus supported on all RDBMS platforms.
On SQL Server, you can alternatively use the TOP operator to obtain a specified number of records from the beginning of the result set, for example, the first 4 records:
You can alternatively pass the argument to TOP as a host variable:
The TOP operator is NOT converted by USoft for platforms other than SQL Server.