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 vote315 views1 answer
T-sql update table variale
SQL
3 votes287 views1 answer
Ssh check mysql version
SQL
0 vote357 views1 answer
Plpgsql create function
SQL
0 vote282 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote316 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
1 vote271 views1 answer
Clear screen command in psql
SQL
4 votes295 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
3 votes305 views5 answers
Foreign keys
SQL
0 vote387 views1 answer
Oracle db timestamp auto add
SQL
0 vote288 views1 answer
Call rest api from postgresql
SQL