What will be the output of the following MySQL statement SELECT...

This question belongs to MySQL MySQL Miscellaneous

MySQL Miscellaneous

What will be the output of the following MySQL statement?

SELECT account_id, product_id, cust_id
FROM account
WHERE product_id NOT IN (‘sav’, ‘chd’, ‘mm’);

A) Only those values are selected whose product_id does not belong to either 'sav', 'chd', 'mm' B) Only those values are selected whose product_id does not belong to either 'sav'' C) Only those values are selected whose product_id does not belong to either 'sav', 'chd' D) All of the mentioned

Answer & Solution

Correct Answer: Option A

Let's discuss the solution. Join the discussion

Question posted by Examveda

Community

Join the Discussion

Join the discussion

No comments yet Be the first to discuss this question.

Keep Learning

What will be the output of the following MySQL statement SELECT...

What will be the output of the following MySQL statement? SELECT account_id, product_id, cust_id FROM account WHERE product_id NOT IN (‘sav’, ‘chd’, ‘mm’);

Join the Discussion

Related Questions on MySQL Miscellaneous

What will be the output of the following MySQL statement?

`SELECT account_id, product_id, cust_id FROM account WHERE product_id NOT IN (‘sav’, ‘chd’, ‘mm’);`