Teradata RANDOM Number

visibility 476 access_time 2 years ago languageEnglish timeline Stats
timeline Stats
Page index 0.78

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.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

More from Kontext
Teradata: Rights on a Database
visibility 56
thumb_up 0
access_time 2 years ago
Teradata: Rights Held by Database
visibility 48
thumb_up 0
access_time 2 years ago
Create Bucketed Sorted Table - Hive SQL
visibility 654
thumb_up 0
access_time 2 years ago