JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Gallery
ECU Handbok Datalagring
Huvudmoment
Databas
API
Säkerhet
Beekeeper Studio
Entity Framework
More
Share
Explore
Nested Queries
Exempel-Querys
The SQL IN Operator
The
IN
operator allows you to specify multiple values in a
WHERE
clause.
The
IN
operator is a shorthand for multiple
OR
conditions.
IN Syntax
SELECT
column_name(s)
FROM
table_name
WHERE
column_name
IN (
value1
,
value2
, ...);
or:
SELECT
column_name(s)
FROM
table_name
WHERE
column_name
IN (
SELECT STATEMENT
);
IN Operator Examples
Example
The following SQL statement selects all customers that are located in "Germany", "France" or "UK":
SELECT * FROM Customers
WHERE Country IN ('Germany', 'France', 'UK');
Example
The following SQL statement selects all customers that are NOT located in "Germany", "France" or "UK":
SELECT * FROM Customers
WHERE Country NOT IN ('Germany', 'France', 'UK');
Example
The following SQL statement selects all customers that are from the same countries as the suppliers:
SELECT * FROM Customers
WHERE Country IN (SELECT Country FROM Suppliers);
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.
