Write a MySQL query to select students with less than 50% marks

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

SELECT * FROM students WHERE marks < 50;

If the marks are out of 100, then marks below 50 are below 50 percent. Use <= to include 50. See MySQL WHERE.

• Previous Interview Question
• Next Interview Question

---

Tutorials
No Content Found.

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.