> > >

MySQL MCQs

How would you retrieve data on all the customers where no phone number is stored?

SELECT * FROM customers WHERE PhoneNumber = NULL;

SELECT * FROM customers WHERE PhoneNumber IS NOT VALID;

SELECT * FROM customers WHERE PhoneNumber IS NULL;

SELECT * FROM customers WHERE PhoneNumber IS UNKNOWN;

Answer

Correct Answer: SELECT * FROM customers WHERE PhoneNumber IS NULL;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it