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 vote312 views1 answer
Sql week commencing date
SQL
4 votes370 views6 answers
List all tables in postgres
SQL
1 vote329 views2 answers
Install mysqldump ubuntu
SQL
2 votes347 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote320 views1 answer
Implizite joins sql
SQL
0 vote346 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote348 views1 answer
What is top n result in sql
SQL
0 vote306 views1 answer
Drop check command
SQL
0 vote320 views1 answer
Use between operator in mysql
SQL
13 votes311 views3 answers
Sql online code
SQL