Loading

SAMPLE

Serverless Preview Stack Preview 9.1.0

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