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 vote177 views1 answer
What is SQL data store?
SQL
15 votes181 views5 answers
If null mysql
SQL
0 vote175 views1 answer
Sql count null as 0
SQL
0 vote176 views1 answer
Database xml sql
SQL
1 vote176 views1 answer
Alphabetical order mysql
SQL
0 vote179 views2 answers
Database owner can't create new tables postgres
SQL
0 vote186 views1 answer
Sql search all columns of database oracle sql
SQL
1 vote176 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote278 views1 answer
Bigrock database connection string
SQL
0 vote162 views1 answer
Create table employees oracle
SQL