If You Want to Compare a Value in a Column

question 32

Multiple Choice

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])