Sql any

Returns true if any of the subquery values meet the given condition.
Example: Returns products from the products table which have received
orders – stored in the orders table – with a quantity of more than 5.
SELECT name
FROM products
WHERE productId = ANY (SELECT productId FROM orders WHERE
quantity > 5);

Similar codes

0 vote256 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote242 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote252 views1 answer
Postgres enumerated type
SQL
1 vote259 views1 answer
Sql delete row with auto increment
SQL
16 votes260 views2 answers
Add column if not exists mysql
SQL
0 vote277 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote260 views1 answer
Where name ends in SQL
SQL
1 vote288 views2 answers
This month mysql where
SQL
0 vote280 views1 answer
Firebase sql
SQL
1 vote266 views1 answer
Mysql search like order by best match
SQL