LIMIT

Administrator Guide

LIMIT

Returns records up to the maximum number that you specify.

Syntax

LIMIT integer

Arguments

Argument	Description
integer	The maximum number of records to return.

Example

Returns the full names for the first 10 records in the

allWorkers

data source:

SELECT fullName
FROM allWorkers
ORDER BY fullName ASC
LIMIT 10

Limitations

LIMIT

value must be greater than zero and less than 1 million.

Because the

LIMIT

clause first retrieves the entire set of results before returning the number of records you specify, using this clause doesn’t improve the performance of your query.