The First prefix to a LOAD or SELECT (SQL) statement is used for loading a set maximum number of records from a data source table.
Syntax:
First n ( loadstatement | selectstatement )
Arguments:
| Argument | Description |
|---|---|
| n |
An arbitrary expression that evaluates to an integer indicating the maximum number of records to be read. n can be enclosed in parentheses, like (n), but this is not required. |
Examples:
First 10 LOAD * from abc.csv;
First (1) SQL SELECT * from Orders;
