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’);

Question

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

Admin · Accepted Answer

Only those values are selected whose product_id does not belong to either 'sav', 'chd', 'mm'

Admin · Answer

Only those values are selected whose product_id does not belong to either 'sav''

Admin · Answer

Only those values are selected whose product_id does not belong to either 'sav', 'chd'

Admin · Answer

All of the mentioned

Q. 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’);

Discusssion

Q. 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’);

Discusssion

Q. 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’);