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 vote120 views1 answer
Clear query cache sql server
SQL
5 votes141 views2 answers
Sql server port number
SQL
4 votes96 views2 answers
Create table if not exists postgres
SQL
0 vote109 views1 answer
Java spring boot connect to sql server
SQL
0 vote135 views2 answers
Mysql updating multiple column values from array variable
SQL
18 votes147 views6 answers
Laravel form validation
SQL
0 vote134 views1 answer
What is between operator
SQL
0 vote135 views1 answer
What is the difference between now() and current_date()?
SQL
9 votes163 views6 answers
Oracle substring
SQL
0 vote134 views1 answer
Oracle simple quote
SQL