rand()

The rand() function returns a random floating-point number between 0 (inclusive) and 1 (exclusive).

Syntax

SELECT RAND()

Examples

-- Generate a random number
SELECT RAND() AS random_value

-- Generate 5 random numbers
SELECT RAND() AS random_value FROM (VALUES(1),(2),(3),(4),(5)) AS t(n)

-- Use in a calculation (random number between 1 and 100)
SELECT ROUND(RAND() * 99 + 1) AS random_1_to_100