SQL IN Keyword Usage and Examples

SQL Keywords Reference

IN

IN

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

The IN operator is a shorthand for multiple OR conditions.

　SELECT　*　FROM Customers
　　The following SQL selects all customers in 'Germany', 'France', and 'UK':

The following SQL selects all customers who are not in 'Germany', 'France', or 'UK':

　SELECT　*　FROM Customers
　　WHERE Country NOT IN ('Germany', 'France', 'UK');

The following SQL selects all customers from the same country as the suppliers:

　SELECT　*　FROM Customers
　　WHERE Country IN (SELECT Country FROM Suppliers);

SQL Keywords Reference