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

10 votes262 views5 answers
Create table mysql query
SQL
0 vote236 views1 answer
Output table plsql
SQL
0 vote261 views1 answer
Authentication modes in sql server
SQL
7 votes263 views2 answers
Mysql check db size
SQL
13 votes249 views2 answers
Sql online compiler
SQL
4 votes275 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote257 views1 answer
Mysql insert into select transaction c#
SQL
6 votes190 views2 answers
Generate c# class from sql server table
SQL
0 vote232 views1 answer
Narural join
SQL
1 vote229 views1 answer
Mysql return text after a final full stop
SQL