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 vote181 views1 answer
Count occurrences sql
SQL
1 vote185 views1 answer
Sql restore backup query
SQL
1 vote183 views1 answer
Sql server datetime vs datetime2
SQL
0 vote206 views1 answer
How to join result table in mysql
SQL
0 vote175 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
4 votes187 views2 answers
Error loading MySQLdb module.
SQL
0 vote176 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote192 views1 answer
Restart sql server command line linux
SQL
2 votes185 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote170 views1 answer
Create function syntax sql server
SQL