[discrete]
[[esql-sample]]
=== `SAMPLE`

preview::[]

The `SAMPLE` command samples a fraction of the table rows.

**Syntax**

[source,esql]
----
SAMPLE probability
----

*Parameters*

`probability`::
The probability that a row is included in the sample. The value must be between 0 and 1, exclusive.

*Example*

[source.merge.styled,esql]
----
include::{esql-specs}/sample.csv-spec[tag=sampleForDocs]
----
[%header.monospaced.styled,format=dsv,separator=|]
|===
include::{esql-specs}/sample.csv-spec[tag=sampleForDocs-result]
|===
