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

2 votes100 views1 answer
SQL IF ELSE
SQL
1 vote354 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote62 views1 answer
How to see the content of tables in pgadmin
SQL
-1 vote113 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
2 votes99 views1 answer
Postgresql change value in column
SQL
21 votes108 views3 answers
Sql average
SQL
-1 vote116 views2 answers
Installing mysql on centos 7
SQL
1 vote106 views2 answers
Difference between in and between in sql
SQL
1 vote137 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote126 views2 answers
Select last 30 days sql
SQL