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 vote98 views1 answer
Replace \n sql
SQL
0 vote100 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
4 votes144 views1 answer
Rename stored procedure in sql server
SQL
0 vote112 views1 answer
Connect by query in oracle
SQL
0 vote105 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote132 views1 answer
Many rows to 1 string mysql
SQL
0 vote105 views1 answer
Check if string is a number sql
SQL
14 votes114 views2 answers
Oracle add attribute to table
SQL
0 vote104 views1 answer
Inner join distinct
SQL
0 vote106 views1 answer
Sql query to check if column contains alphabets
SQL