Contents Index RADIANS function [Numeric] REMAINDER function [Numeric]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

RAND function [Numeric]


Function 

Returns a random number in the interval 0 to 1, with an optional seed.

Syntax 

RAND ( [integer-expression)

Parameters 

integer expression    The optional seed used to create a random number. This argument allows you to create repeatable random number sequences.

Usage 

RAND is a non-deterministic function. Successive calls to RAND may return different values. The query optimizer does not cache the results of the RAND function.

For more information about non-deterministic functions, see Function caching.

Standards and compatibility 
Example 

The following statement returns a value of approximately 0.0554504.

SELECT RAND( 4 )

Contents Index RADIANS function [Numeric] REMAINDER function [Numeric]