Question

Sarthak, a student of class XII, created a table "Class". Grade is one of the columns of this table. To find the details of students whose Grades have not been entered, he wrote the following MySQL query, which did not give the desired result.

SELECT * FROM Class where GRADE = "Null";

Help Sarthak to run the query by removing the errors from the query and write the correct Query.

Answer 1

SELECT * FROM Class WHERE Grade IS NULL;