Skip to main content Skip to complementary content

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;

Learn more

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!