limit.asciidoc 316 B

12345678910111213
  1. [discrete]
  2. [[esql-limit]]
  3. === `LIMIT`
  4. The `LIMIT` processing command enables you to limit the number of rows:
  5. [source,esql]
  6. ----
  7. include::{esql-specs}/docs.csv-spec[tag=limit]
  8. ----
  9. If not specified, `LIMIT` defaults to `500`. A single query will not return
  10. more than 10,000 rows, regardless of the `LIMIT` value.