# 
## Overview

The `random()` function of postgreSQL is used to return a random number between `0` and `1`. This function can be used to generate a random number within a range.

## Syntax

```sql
random()
```

## Parameters

This function doesn't take any parameters.

## Example 1


# 
## Example 2

To generate a random number between two integers, the following SQL can be used.

We're assuming the integer range to be `low` and `high` where `low` indicates the lowest possible integer and `high` indicates the highest possible integer in the range.

```sql
SELECT floor(random() * (high - low + 1) + low)::int;
```

## Example 3

SELECT floor(random() * (1000 - 1 + 1) + 1)::int as random_number;

In the code above, we generate a random integer between `1` and `1000` where `1` is low and `1000` is high.

How to generate random numbers in postgreSQL

PostgreSQL's `random()` generates random numbers between 0 and 1 and within specified integer ranges.