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 vote269 views1 answer
Jooq replace
SQL
4 votes311 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
1 vote292 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote277 views1 answer
Leftjoin in sql
SQL
23 votes270 views3 answers
Mysqldump
SQL
1 vote294 views1 answer
Where not in array sql
SQL
0 vote298 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote270 views2 answers
Install phoenix
SQL
11 votes285 views1 answer
Oracle view ddl
SQL
0 vote271 views1 answer
Sql server order by nulls last
SQL