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 votes316 views1 answer
Oracle index size calculation
SQL
0 vote347 views1 answer
Oracle sql alter view add column
SQL
0 vote305 views1 answer
Import all databases mysql
SQL
0 vote339 views1 answer
Product of a column in mysql
SQL
0 vote322 views1 answer
Mysql select all table that have field names
SQL
0 vote324 views1 answer
Copy Table from SQL to CSV
SQL
0 vote314 views2 answers
Sql update top 100
SQL
0 vote337 views1 answer
Oracle drop type
SQL
1 vote318 views2 answers
Mysql join two tables
SQL
0 vote317 views1 answer
Mysql grant user wildcard database
SQL