`SAMPLE`

Stack Preview 9.1.0 Serverless Preview

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
		
	