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.
// tag::limitation[]
Queries do not return more than 10,000 rows, regardless of the `LIMIT` command's
value.

This limit only applies to the number of rows that are retrieved by the query.
Queries and aggregations run on the full data set.

To overcome this limitation:

* Reduce the result set size by modifying the query to only return relevant
data. Use <<esql-where>> to select a smaller subset of the data.
* Shift any post-query processing to the query itself. You can use the {esql}
<<esql-stats-by>> command to aggregate data in the query.

The default and maximum limits can be changed using these dynamic cluster
settings:

* `esql.query.result_truncation_default_size`
* `esql.query.result_truncation_max_size`
// end::limitation[]

*Example*

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