Multiple choice sql

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

  1. SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

  2. SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

  3. SELECT NAME IN CUSTOMER WHERE STATE = 'V'

  4. SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Using IN with a single-value list is equivalent to using = for comparison. Both queries return names of customers from Virginia. The IN operator is typically used with multiple values, but works identically with one.

Keep practicing — related questions