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 is used. The default limit is set to 100,000.

Example

Limits Expression	Definition
limit 100	Limits the result set to top 100 rows.