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 vote337 views4 answers
Mysql replace regex
SQL
-2 votes374 views1 answer
How-to-remove-mysql-root-password
SQL
4 votes358 views3 answers
How to describe a table in sqlite3
SQL
-1 vote366 views1 answer
Condition in orderby mysql
SQL
2 votes327 views1 answer
Convert series number to date in sql
SQL
0 vote319 views1 answer
Deleted table in sql trigger
SQL
10 votes316 views1 answer
Oracle view dependencies
SQL
0 vote334 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote368 views1 answer
Cannot start database server xampp mac os
SQL
0 vote341 views2 answers
Python mysql create table if not exists
SQL