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 vote147 views1 answer
Mysql workbench search all tables
SQL
0 vote235 views1 answer
Mysql subtract month from timestamp
SQL
0 vote188 views1 answer
Sql orcale i forgot what my name & password was
SQL
5 votes235 views2 answers
Mysql where in array
SQL
3 votes218 views1 answer
Postgres update column with value from another table
SQL
0 vote207 views1 answer
Multiple like values for single column postgres
SQL
6 votes186 views1 answer
Postgresql add enum value
SQL
14 votes268 views1 answer
How to export db from mysql
SQL
0 vote203 views1 answer
How to set up an anonymous function to variable in swift
SQL
7 votes195 views1 answer
Set sequence value oracle
SQL