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

6 votes304 views3 answers
Commit in sql
SQL
0 vote370 views1 answer
Redshift running queries
SQL
0 vote320 views1 answer
Mysql get hour from datetime
SQL
1 vote307 views1 answer
Retrieve meaning
SQL
1 vote289 views3 answers
Mysql disable foreign keys check
SQL
24 votes283 views4 answers
Mssql get all table names
SQL
2 votes288 views1 answer
Add 2 hours to current time in MySQL
SQL
5 votes308 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote292 views1 answer
Load utilities in sql server
SQL
0 vote308 views1 answer
Mysql set variable to today's date
SQL