RANDOM Function Example | VantageCloud Lake - Example: Returning Random Integer Numbers as Results - Teradata VantageCloud Lake

Suppose you have a table named sales_table with the following subset of columns.

The following SELECT statement returns a random number between 1 and 3, inclusive, for each row in the results table.

SELECT store_id, product_id, sales, RANDOM(1,3)
FROM sales_table;

The results table may look like this.