Sometimes we do want some randomness in our queries.
To generate a random float number between 0 and 1 we can use the
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.
RANDOM() function could be used to categorize our users for an email AB-test:
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.