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 vote292 views1 answer
Database run
SQL
0 vote321 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote337 views1 answer
C# mysql update statement set value to null
SQL
0 vote549 views1 answer
Get first match in each group mysql query
SQL
0 vote350 views1 answer
Copy data from one postgres container to another
SQL
8 votes338 views2 answers
Select table column name in sql
SQL
0 vote307 views1 answer
How to get inserted id in sql server
SQL
0 vote341 views1 answer
Consulta alias con inner join
SQL
8 votes347 views1 answer
Check mysql version phpmyadmin
SQL
0 vote312 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL