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

Description:

Table name is “student” and You need to select all students whom marks are less than 50%.

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

Solution/Query:

You need to put condition in “WHERE” clause

SELECT * FROM student WHERE marks < 50

• Previous Interview Question
• Next Interview Question

---

Tutorials
No Content Found.

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.