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 vote61 views1 answer
Mysql sleep connections
SQL
11 votes101 views5 answers
How to install sqlite3 python
SQL
3 votes99 views1 answer
Start mysql server linux terminal
SQL
1 vote101 views1 answer
Sql how to duplicate a table
SQL
0 vote99 views1 answer
Mysql multiple group by
SQL
2 votes55 views1 answer
Mysql admin u root p password change password
SQL
2 votes107 views3 answers
How to get second highest salary in each department in sql
SQL
11 votes103 views3 answers
Change column name sql server management studio
SQL
1 vote84 views1 answer
Pentaho + pasar de excel a sql
SQL
0 vote106 views1 answer
Mysql select distinct date from timestamp
SQL