SQL IN CLAUSE

IN OPERATOR:

The IN operator allows you to specify multiple values in a WHERE clause.

SYNTAX:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name IN (val-1, val-2,...val-N);

EXAMPLE:

SELECT * FROM  STUDENT
WHERE CLASS IN ('first','second');

Displays all the columns of the table student where the class is having either first or second.