IN

SQL IN Keyword

The IN operator is used in a WHERE clause to help filter rows based on whether a column’s value matches any value from a list. It works like a cleaner version of using multiple OR conditions.

Tutorials dojo strip

SQL IN Syntax

SQL

You can also use it with a subquery:

SQL

SQL IN Matching Multiple Values Example

SQL

SQL IN Excluding Values Using NOT IN Example

SQL

SQL IN Using A Subquery Example

SQL

SQL IN Labs

Tutorials dojo strip