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. |