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 vote154 views1 answer
Redudancy in SQL
SQL
2 votes171 views1 answer
Coalesce sql
SQL
1 vote143 views1 answer
Postgres killing connections on db
SQL
2 votes100 views1 answer
Sql select in list
SQL
0 vote154 views1 answer
Open postgresql.conf in centos
SQL
0 vote117 views1 answer
Mysql offset from bottom
SQL
2 votes151 views1 answer
Compare date in sql
SQL
9 votes171 views3 answers
Where clause sql
SQL
-2 votes149 views1 answer
Group functions in sql
SQL
0 vote115 views1 answer
Raven ql select count
SQL