Sql where clause multiple values

Sql where multiple values

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

Source: grepper.com

Specify multiple values in a WHERE clause SQL

-- The IN operator allows you to specify multiple values in a WHERE clause.
SELECT example_column
FROM exaple_table
WHERE example_column IN (example_value1, example_value2, example_value3);

Source: campus.datacamp.com

Similar codes

0 vote351 views2 answers
Cascade syntax in sql
SQL
5 votes350 views1 answer
How to check nls format in oracle
SQL
0 vote357 views1 answer
How to select an index in oracle sql
SQL
0 vote360 views1 answer
EnvironmentError: mysql_config not found
SQL
10 votes369 views2 answers
Rtrim sql
SQL
0 vote345 views2 answers
Getting customers with no orders sql
SQL
0 vote360 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote345 views1 answer
Many rows to 1 string mysql
SQL
0 vote345 views1 answer
Show create table in postgresql
SQL
0 vote364 views3 answers
How to increase size of column in sql
SQL