Skip
Arish's avatar

31. BETWEEN with Other Conditions

Combining BETWEEN with AND

sql
1SELECT * FROM students
2WHERE marks BETWEEN 70 AND 90
3AND course = 'Python';

Example

Python students with marks 75-85:

sql
1SELECT * FROM students
2WHERE course = 'Python'
3AND marks BETWEEN 75 AND 85;

With OR

sql
1SELECT * FROM students
2WHERE marks BETWEEN 80 AND 90
3OR grade = 'A';