SAMPLE
Serverless Stack
The SAMPLE command samples a fraction of the table rows.
Syntax
SAMPLE probability
Parameters
probability- The probability that a row is included in the sample. The value must be between 0 and 1, exclusive.
Examples
FROM employees
| KEEP emp_no
| SAMPLE 0.05
| emp_no:integer |
|---|
| 10018 |
| 10024 |
| 10062 |
| 10081 |