SQL IN

Previous | Next

SQL > SQL Advanced > SQL IN

What is SQL IN?

The SQL IN operator enables a comparison to a list of values or to the results of a SUBSELECT.

Why Use SQL IN?

The SQL IN operator is a clean way to check for inclusion in lists without creating a series of OR clauses.

How To Use SQL IN

SQL IN is used as follows.

SQL IN Syntax

SELECT <column_list>
FROM <table_name>
WHERE <column_name IN (value_list)>

There must be one or more members of the value_list. Numeric and non-numeric values are supported.

SQL IN Example

The following example selects information from the BRANCH where the region_nbr is IN a specified list of region_nbr values.

Here are the contents of the table:

Table: BRANCH

branch_nbr branch_name region_nbr employee_count

108 New York 100 10

110 Boston 100 6

212 Chicago 200 5

404 San Diego 400 6

415 San Jose 400 3

This SQL Statement with IN is executed:

SELECT branch_nbr, branch_name, region_nbr
FROM branch
WHERE region_nbr IN (200, 400)

Here is the result.

branch_nbr branch_name region_nbr

108 New York 100

415 San Jose 400