Prev Next

IN Operator

The IN operator is used to filter records where a value matches any value in a specified list or subquery.

Example: Using IN

SELECT Name, City
FROM FreedomFighters
WHERE City IN ('Chennai', 'Madurai', 'Trichy');

Output:

Returns the names and cities of freedom fighters from Chennai, Madurai, or Trichy.

Do's and Don'ts

Do's

  • Use IN for cleaner and more readable queries when checking against multiple values.
  • Ensure the list of values is not too large to avoid performance issues.

Don'ts

  • Don't use IN with a large list of values; consider using a join instead.
  • Don't use IN unnecessarily when a simple equality check will do.
Prev Next