First

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;

See also: