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 vote75 views1 answer
Copy data from cell to cell mysql
SQL
0 vote106 views1 answer
Print orcale
SQL
0 vote134 views1 answer
Cartesian product sql
SQL
2 votes114 views1 answer
Oracle sql drop table purge
SQL
18 votes121 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
8 votes124 views1 answer
Oracle add datafile to tablespace
SQL
0 vote121 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote108 views1 answer
Sql put two columns into one
SQL
0 vote113 views1 answer
Sql developer search all packages for text
SQL
0 vote135 views2 answers
Get value from a table an insert it with other values in another table sql
SQL