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 vote270 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote318 views2 answers
Execute stored procedure without db set
SQL
11 votes193 views5 answers
How to install sqlite3 python
SQL
0 vote196 views1 answer
Postpresql relation not found
SQL
6 votes186 views1 answer
Phpmyadmin reset root password
SQL
0 vote206 views1 answer
How to run mysql in git bash
SQL
0 vote186 views1 answer
Ffeathers express mysql application users login
SQL
1 vote217 views1 answer
Convert to hexadecimal sql
SQL
0 vote306 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote189 views1 answer
Assign value to var in SQL
SQL