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.