Write a MySQL query to select students with marks between 70 and 80

The examples use the students table from our MySQL tutorial: id, name, city, marks, course_id.

SELECT * FROM students WHERE marks BETWEEN 70 AND 80;

BETWEEN includes 70 and 80 themselves. It is the same as marks >= 70 AND marks <= 80. See IN, BETWEEN and IS NULL.

• Previous Interview Question
• Next Interview Question

---

Tutorials
No Content Found.

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.