×
Night mode
Sign up
Login
BETWEEN
Select all students with points between 80 and 90 (using BETWEEN AND operator)
SELECT *
FROM students
WHERE points BETWEEN 80 AND 90
We can get the same result by using 
AND
logical operator
SELECT *
FROM students
WHERE points >= 80
    AND points <= 90
by Valeri Tandilashvili
4 years ago
MySQL
BETWEEN
MySQL Tutorial for Beginners
1
Pro tip: use ```triple backticks around text``` to write in code fences