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 vote374 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote362 views1 answer
Migrations.RunSQL
SQL
1 vote392 views1 answer
Sqlalchemy on delete set null
SQL
0 vote374 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote305 views2 answers
Denormalization in sql
SQL
31 votes359 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote340 views1 answer
How to remove default in mysql
SQL
1 vote349 views1 answer
Postgres get timestamp
SQL
7 votes365 views3 answers
Restore postgres database from sql file
SQL
3 votes372 views2 answers
Enter mysql command line
SQL