sort.asciidoc 894 B

123456789101112131415161718192021222324252627282930313233343536
  1. [[esql-sort]]
  2. === `SORT`
  3. Use the `SORT` command to sort rows on one or more fields:
  4. [source,esql]
  5. ----
  6. include::{esql-specs}/docs.csv-spec[tag=sort]
  7. ----
  8. The default sort order is ascending. Set an explicit sort order using `ASC` or
  9. `DESC`:
  10. [source,esql]
  11. ----
  12. include::{esql-specs}/docs.csv-spec[tag=sortDesc]
  13. ----
  14. Two rows with the same sort key are considered equal. You can provide additional
  15. sort expressions to act as tie breakers:
  16. [source,esql]
  17. ----
  18. include::{esql-specs}/docs.csv-spec[tag=sortTie]
  19. ----
  20. [discrete]
  21. ==== `null` values
  22. By default, `null` values are treated as being larger than any other value. With
  23. an ascending sort order, `null` values are sorted last, and with a descending
  24. sort order, `null` values are sorted first. You can change that by providing
  25. `NULLS FIRST` or `NULLS LAST`:
  26. [source,esql]
  27. ----
  28. include::{esql-specs}/docs.csv-spec[tag=sortNullsFirst]
  29. ----