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 vote162 views1 answer
Sql in array query
SQL
0 vote160 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote134 views1 answer
Select if then postgresql
SQL
1 vote134 views1 answer
Pl sql create table from another table
SQL
0 vote132 views1 answer
Sql inserted
SQL
1 vote136 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
1 vote124 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote151 views1 answer
Remove transient options sql wordpress
SQL
3 votes168 views3 answers
Restart mysql mac
SQL
1 vote135 views1 answer
Sql server datetime vs datetime2
SQL