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 vote326 views1 answer
Write sql query to show the details start from digit
SQL
4 votes351 views3 answers
Is not null sql
SQL
0 vote349 views2 answers
Enter into postgresql database,create user and grant Access
SQL
5 votes348 views1 answer
Oracle sysdate - 1 month
SQL
27 votes347 views5 answers
Add column in table
SQL
103 votes544 views2 answers
Sql server LIKE '%%'
SQL
0 vote408 views1 answer
Delete ids between sql
SQL
1 vote336 views2 answers
Change table name phpmyadmin
SQL
0 vote363 views1 answer
Sql delimiter to columns
SQL
2 votes311 views2 answers
Select multiple tables mysql
SQL