If you want to compare a value in a column against a list of values, which syntax would you use?
A)WHERE [Column Name] LIKE ([Value1], [Value2], [Value3])
B)WHERE [Column Name] = ([Value1], [Value2], [Value3])
C)WHERE [Column Name] IN ([Value1], [Value2], [Value3])
D)WHERE [Column Name] EXISTS ([Value1], [Value2], [Value3])

Question

Quizplus · Accepted Answer

To compare a value in a column against a list of values, the IN operator is used. The syntax for using the IN operator is "WHERE [column name] IN ([value1], [value2], [value3])". Therefore, the correct syntax is C.

If You Want to Compare a Value in a Column