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

1 vote229 views1 answer
Sql sort column by date
SQL
4 votes234 views1 answer
List tables sqlite
SQL
0 vote237 views1 answer
Top 3 salary in sql
SQL
0 vote231 views1 answer
Sql remove non numeric characters
SQL
2 votes226 views1 answer
Mariadb select multiple rows into one column
SQL
-1 vote247 views5 answers
Not in sql
SQL
0 vote240 views1 answer
Database traccar
SQL
15 votes243 views6 answers
Drop foreign key mysql
SQL
1 vote243 views1 answer
Sql drop schema
SQL
2 votes234 views2 answers
Set database timezone mysql
SQL