RANDOM()

Scalar. Returns a random value greater than or equal to 0 and less than 1.

Syntax

RANDOM()

Data Types
Return
Float

The following example uses the RANDOM function to generate a new stock price up to 10% higher than its original value:

INSERT INTO OutStream
SELECT (1 + RANDOM() /10.0) * Trades.StockPrice
FROM Trades;