Which keyword is used with the WHERE clause in SQL to compare multiple values?

Correct option is A

The IN keyword is used with the WHERE clause to compare multiple values.
Important Key Points:
1. The IN keyword allows specifying multiple values in a WHERE clause, enabling filtering of rows that match any value in the list.
2. Example: SELECT * FROM table_name WHERE column_name IN (value1, value2);
Knowledge Booster:
· BETWEEN is used to filter rows based on a range of values.
· LIKE is used for pattern matching with wildcards.
· HAVING is used for filtering groups, not individual rows, in conjunction with aggregate functions.
· EXISTS checks for the existence of rows in a subquery.