Numbers & math Scalar

random()

Returns a random number between 0 and 1

Arguments & returns

Scalar

Overload link	Returns
#01	`DOUBLE`

SELECT random();

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Used in larger rewrites 2

These examples use random as one part of a larger SQL translation.

SELECT * FROM "test_table" ORDER BY RANDOM() LIMIT 5

In Haybarn

SELECT * FROM "test_table" ORDER BY RANDOM() LIMIT 5

SELECT RANDOM()

In Haybarn

SELECT CAST(-9.223372036854776E+18 + RANDOM() * (9.223372036854776e+18 - -9.223372036854776E+18) AS BIGINT)