Teradata RANDOM Number
insights Stats
warning Please login first to view stats information.
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_bound and upper_bound range from -2147483648 to 2147483647 inclusively and upper_bound must be greater or equal to lower_bound.
Example
SELECT RANDOM(1,1000);
The output will be a random number between 1 and 1000.
copyright
This page is subject to Site terms.
comment Comments
No comments yet.