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’);
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: Option A
This Question Belongs to MySQL >> MySQL Miscellaneous
Join The Discussion