1.7 Retrieving data that meets one of multiple conditions (IN predicate)

Use the IN predicate if you want to specify multiple conditions (values) and retrieve data that match any one of them. The specification format of the IN predicate is as follows.

Specification format

SELECT "column-name" FROM "table-name"
    WHERE "column-name" IN (value-1,value-2,...)

column-name:

Specify the column to use for narrowing down the retrieval.

IN (value-1, value-2, ...):

Specify the values to be retrieved. Rows that match any of the values specified here will be retrieved.

Note

For details about the syntax of the IN predicate, see 7.19.3 IN predicate.

Organization of this section

• 1.7.1 Example 1: Retrieve customers who purchased product code P001 or P003

• 1.7.2 Example 2: Retrieve customers who purchased products except for a specific customer

To Page Top