elasticsearch/docs/reference/esql/processing-commands/limit.asciidoc

[discrete]
[[esql-limit]]
=== `LIMIT`

**Syntax**

[source,esql]
----
LIMIT max_number_of_rows
----

*Parameters*

`max_number_of_rows`::
The maximum number of rows to return.

*Description*

The `LIMIT` processing command enables you to limit the number of rows that are
returned. If not specified, `LIMIT` defaults to `500`.

A query does not return more than 10,000 rows, regardless of the `LIMIT` value.
You can change this with the `esql.query.result_truncation_max_size` static
cluster setting.

*Example*

[source,esql]
----
include::{esql-specs}/docs.csv-spec[tag=limit]
----