16.20 - Example: Returning Random Integer Numbers as Results - Advanced SQL Engine - Teradata Database

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 might look like this.