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

Description:

Table name is “student” and You need to select all students where marks are between 70 and 80%.

id	student_name	marks
1	Amit	46
2	Tome	78
3	Robin	59
4	Rocky	40
5	Tonny	55

Solution/Query:

MySQL BETWEEN Operator is used to specify range of values in condition.

SELECT * FROM student WHERE marks BETWEEN 70 and 80

• Previous Interview Question

---

Tutorials
No Content Found.

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.