You are here

IN - One of a Set of Values

Syntax

Description:

    WW IN ( Value [,...] ) tells the DBMS , that WW must be one of the values in the specifyed valuelist.

    Example:

SELECT *
 FROM torder
 WHERE preis IN (100,200,300,400,500);

Here are all records from the table torder selected, where preis have one of the values in the specifyed list.