SQL Keywords: IS



The IN keyword is used to select one from a group of values. The formula to follow is:

IN(Expression1, Expression2, Expression_n)

Each Expression factor can be one of the values of a column. This is equivalent to Expression1 OR Expression2 OR Expression3, etc.

Here is an example that shows the list of movies directed by either Oliver Stone or Ron Howard:

SELECT Videos.Title, Videos.Director, Videos.CopyrightYear, Videos.Rating
FROM Videos
WHERE (Videos.Director) IN ("Oliver Stone","Ron Howard");

Home Copyright © 2009-2016, FunctionX, Inc.