Let’s review all the scalar functions from the course that deal with numbers (and a little more):
1. RANDOM()
The RANDOM()
function returns a random float number between 0 and 1:
SELECT RANDOM()
We can use to get random records sample with ORDER BY RANDOM()
.
2. ROUND(number, precision = 0)
The ROUND()
function takes two arguments – a number and how many float digits we want to have:
SELECT ROUND(3.141592654, 3)
We use ROUND()
to avoid numbers like 43.33333333333
in the query result (it really makes the result unreadable + when dealing with...
Buy access to SQL Habit course and all Practice exercises forever.
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. 