SQLite random() Function

The SQLite random() function returns a pseudorandom integer between -9223372036854775808 and +9223372036854775807.

Syntax

Here is the syntax of the SQLite random() function:

random()

Parameters

The SQLite random() function does not require any parameters.

Return value

The SQLite random() function returns a pseudorandom integer between -9223372036854775808 and +9223372036854775807.

Examples

This example shows how to use the SQLite random() function to get a random integer.

SELECT
    random(),
    random();

random() = -835783738580148834
random() = -802917661299892691