RANDOM function in Teradata returns a random integer number for each row of the results table. It is a Teradata extension to the ANSI SQL:2011 standard.
Function syntax
Random(lower_bound, upper_bound)
The limits forĀ lower_boundand upper_boundrange from -2147483648 to 2147483647 inclusively and upper_boundmust be greater or equal to lower_bound.
Example
SELECT RANDOM(1,1000);
The output will be a random number between 1 and 1000.