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.


First n ( loadstatement | selectstatement )


Argument Description

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.


First 10 LOAD * from abc.csv;

First (1) SQL SELECT * from Orders;

See also:


Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?