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 vote339 views1 answer
Sql server get users
SQL
1 vote363 views1 answer
How to test for sql injection
SQL
0 vote356 views1 answer
Mysql select inside sum
SQL
42 votes456 views6 answers
Rename table sql server
SQL
0 vote356 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
3 votes356 views1 answer
Oracle list user grants
SQL
2 votes342 views3 answers
Current month mysql query
SQL
10 votes345 views4 answers
Sql pagination
SQL
0 vote358 views1 answer
T-SQL Create Trigger
SQL
6 votes350 views2 answers
Mysql get yesterday
SQL