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

5 votes218 views2 answers
Get number of columns sql
SQL
0 vote203 views1 answer
Sqlcmd no headers
SQL
4 votes216 views2 answers
Linq join
SQL
0 vote197 views1 answer
Get db connection detail from sql developer profile
SQL
7 votes210 views6 answers
Group_concat in mysql
SQL
0 vote214 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote211 views1 answer
Xamarin sql lite create table if not exist
SQL
1 vote203 views1 answer
Add current timestamp in mysql
SQL
1 vote207 views1 answer
Mysql select if empty result
SQL
1 vote207 views1 answer
Md5 encryption for existing records
SQL