WHERE product_id NOT IN &#40;‘sav’, ‘chd’, ‘mm’&#41;;
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 above
Answer:A
WHERE product_id NOT IN &#40;‘sav’, ‘chd’, ‘mm’&#41;;
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 above
Explanation: “NOT IN” worked opposite of “IN” operator