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 vote220 views1 answer
Hour differeence in mysql
SQL
1 vote210 views2 answers
Mysql switch case
SQL
0 vote203 views1 answer
Soql queries for not contact related account records in salesforce
SQL
7 votes220 views5 answers
Max 3 salary in sql
SQL
14 votes236 views2 answers
Oracle add attribute to table
SQL
0 vote250 views2 answers
Mysql add days to date
SQL
0 vote221 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote188 views1 answer
Java spring boot connect to sql server
SQL
0 vote205 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
1 vote276 views2 answers
Mysql SELECT
SQL