Example
Return a random decimal number (no seed value - so it returns a completely random number >= 0 and <1):
sql
SELECT RAND();
Definition and Usage
The RAND() function returns a random number between 0 (inclusive) and 1 (exclusive).
Syntax
text
RAND(seed)
Parameter Values
| Parameter | Description |
|---|---|
| seed | Optional. If seed is specified, it returns a repeatable sequence of random numbers. If no seed is specified, it returns a completely random number |
Technical Details
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse |
|---|
More Examples
Example
Return a random decimal number (with seed value of 6):
sql
SELECT RAND(6);
Example
Return a random decimal number >= 5 and <10:
sql
SELECT RAND()*(10-5)+5;
Example
Return a random number >= 5 and <=10:
sql
SELECT FLOOR(RAND()*(10-5+1)+5);