Multiple choice

The 'IN SQL' keyword

  1. is used with the DISTINCT SQL keyword only

  2. is used with the INSERT SQL keyword only

  3. determines if a value matches any of the values in a list or a sub-query

  4. defines the tables we are selecting or deleting data from
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The IN operator in SQL tests whether a value matches any value in a specified list or any value returned by a subquery. It is not limited to DISTINCT or INSERT keywords, and FROM (not IN) defines the tables for SELECT or DELETE operations.

Keep practicing — related questions