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 vote199 views1 answer
Phinehas Psalm 106
SQL
1 vote203 views2 answers
Sql server concat string and int
SQL
0 vote219 views1 answer
How to access to mysql without root
SQL
2 votes228 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote195 views1 answer
Array aggre distinct postgres
SQL
0 vote192 views1 answer
Sql find leading space
SQL
8 votes191 views3 answers
Oracle auto_increment
SQL
0 vote184 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote191 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote185 views1 answer
Get who is hired in specific month in sql
SQL