SAMPLE

The SAMPLE function returns an arbitrary value from the specified set of values.

SAMPLE Syntax

Use the following syntax when incorporating the SAMPLE function in queries:

SAMPLE(expression)

Note: A GROUP BY statement is required for queries that contain SAMPLE functions if the results clause lists non-aggregate variables. Include all non-aggregated variables in the GROUP BY statement.