LIMIT Statement

LIMIT indicates the maximum number of results that should be returned by the query.

<limitStatement> ::= "LIMIT" <number> ;

If you do not specify a LIMIT clause in the query, the default limit of 100,000 is used.

Example

USE system | LIMIT 100
Expression Definition
limit 100 Limits the result set to top 100 rows.