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...
âwell worth the moneyâ
Sign up and check out 36 free lessons and exercises.
About SQL Habit
Hi, itâs Anatoli, the author of SQL Habit. 
SQL Habit is a course (or, as some of the students say, âbusiness simulatorâ). Itâs based on a story of a fictional startup called Bindle. Youâll play a role of their Data Analyst
and solve real-life challenges from Business, Marketing, and Product Management.
SQL Habit course is made of bite-sized lessons (youâre looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything youâve learned at work. 