Skip to main content


1. RAND Function

The RAND function in H2 database is used to generate a random value between 0 (inclusive) and 1 (exclusive).

2. Syntax

The syntax for the RAND function in H2 database is as follows:



  • This function does not require any arguments.


  • The RAND function returns a random value between 0 (inclusive) and 1 (exclusive).

3. Notes

  • The RAND function in H2 database generates a new random value each time it is called.
  • The generated random value is of type DOUBLE.
  • If you need to generate a random integer within a specific range, you can use the RANDOM function along with FLOOR or CEILING to round the result accordingly.

4. Examples

Here are a few examples demonstrating the usage of the RAND function in H2 database:

Example 1 - Generating a random value:

SELECT RAND() AS random_value;



Example 2 - Generating multiple random values:

SELECT RAND() AS random_value1,
RAND() AS random_value2,
RAND() AS random_value3;


random_value1  | random_value2  | random_value3
0.825367195883 | 0.170303372837 | 0.712188694428
  • RANDOM - Generate a random number within a specified range.
  • floor - Round a number down to the nearest integer.
  • CEILING - Round a number up to the nearest integer.