255. Random in SQL

Sometimes we do want some randomness in our queries.

To generate a random float number between 0 and 1 we can use the RANDOM() function:

Random number

SELECT RANDOM() 

We could easily modify this function to generate an integer random number within a range (for example, between 21 and 89):

SELECT ROUND(RANDOM() * (89 - 21) + 21) 

As you can see the formula to generate an integer number from a range is RANDOM() * (range_top - range_bottom) + range_bottom.

The RANDOM() function could be used to categorize our users for an email AB-test:

SELECT...