Question

Sukhdev has created a relation Teacher (Teacher_ID, First_Name, Last_Narne, Gender, Date_of_Birth, Salary, Dep_No). Help him to identify the correct query to display all the records of Teacher with no last name.

(a) Select * from Teacher where First name is not null;

(b) Select * from Teacher where Last_name = NULL;

(c) Select * from Teacher where Last_name is NULL;

(d) Select * from Teacher where Last name = is NULL;

Answer 1

Correct option is (c) Select * from Teacher where Last_name is NULL;