access_time 11 months ago languageEnglish
more_vert

Teradata RANDOM Number

visibility 195 comment 0

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.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Follow Kontext

Get our latest updates on LinkedIn.

Want to contribute on Kontext to help others?

Learn more

More from Kontext

visibility 1312
thumb_up 0
access_time 4 years ago
visibility 1303
thumb_up 0
access_time 11 months ago
visibility 746
thumb_up 0
access_time 8 months ago