Question

In an SQL query, which SQL keyword is used to determine if a column value is equal to any one of a set of values?

a) AND
b) EXISTS
c) HAVING
d) IN
e) OR

Answer 1

The SQL keyword to check if a column value matches any value in a set is 'IN', used within a WHERE clause.

Step-by-step explanation:

In an SQL query, the IN keyword is used to determine if a column value is equal to any one of a set of values. It allows you to specify multiple values in a WHERE clause. For example, if you want to select all students who have scored either 90, 95, or 100 on a test, you would write: SELECT * FROM students WHERE test_score IN (90, 95, 100);. This query would return all rows where the test_score column has values 90, 95, or 100.