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 vote187 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
1 vote145 views2 answers
Sql server add time to date
SQL
1 vote206 views1 answer
Size of all tables in a schema oracle
SQL
0 vote142 views1 answer
Create a table from one field of another table
SQL
0 vote106 views2 answers
Postgresql could not start server mac
SQL
0 vote140 views2 answers
Sql join on wildcard
SQL
1 vote168 views1 answer
Autocommit mysql
SQL
19 votes148 views5 answers
Change column name mysql command line
SQL
0 vote223 views1 answer
How to show current database in mysql
SQL
0 vote148 views1 answer
See Foreign Key
SQL