SQL at work Random in SQL

253. 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


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:

“well worth the money”
Sign up and check out 36 free lessons and exercises.

Anatoli Makarevich, author of SQL Habit 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. 🚀

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.
-- Type your query here, for example this one -- lists all records from users table: SELECT * FROM users
Loading chart... ⏳