> > >

MySQL MCQs

How would you select all the user_name values from records whose user_phonenumber field is null?

SELECT user_name FROM users WHERE user_phonenumber;

SELECT user_name FROM users WHERE user_phonenumber IS NULL;

Any of these three statements may work, depending on the version of MySQL being used.

SELECT user_name FROM users WHERE user_phonenumber = NULL;

Answer

Correct Answer: SELECT user_name FROM users WHERE user_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