SQL IN Operator

« Previous Chapter Next Chapter »

The IN Operator

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

SQL IN Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...)

IN Operator Example

The "Persons" table:

P_Id LastName FirstName Address City
1 Karmen Kasa Los Angels - USA New Orleans
2 Jacob Mary Los Angels - USA New Orleans
3 Maxwell Glen Australia Sydney

Now we want to select the persons with a last name equal to "Karmen" or "Maxwell" from the table above.

We use the following SELECT statement:

SELECT * FROM Persons
WHERE LastName IN ('Karmen','Maxwell')

The result-set will look like this:

P_Id LastName FirstName Address City
1 Karmen Kasa Los Angels - USA New Orleans
3 Maxwell Glen Australia Sydney

« Previous Chapter Next Chapter »
Have Any Suggestion? We Are Waiting To Hear from YOU!

Your Query was successfully sent!