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

3 votes132 views1 answer
Index using in query plsql
SQL
-1 vote138 views3 answers
Error mysql shutdown unexpectedly
SQL
2 votes142 views1 answer
Oracle table size
SQL
0 vote137 views1 answer
Postgresql interview questions
SQL
0 vote148 views1 answer
Download mysql database to excel in android studio
SQL
0 vote130 views1 answer
Sqldf change user
SQL
0 vote162 views1 answer
Sql count total by foreign key
SQL
25 votes137 views6 answers
Import mysql database command line
SQL
0 vote141 views1 answer
Postgres 11 add primary key
SQL
0 vote158 views1 answer
How to change mysql port in xampp
SQL