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 vote137 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote134 views1 answer
Mysql with
SQL
0 vote230 views1 answer
Bigrock database connection string
SQL
0 vote133 views1 answer
Sql check for null and empty string
SQL
2 votes145 views2 answers
Mysql find max value row
SQL
5 votes161 views1 answer
Oracle create table comment
SQL
0 vote134 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote148 views2 answers
Identity column in sql server
SQL
0 vote147 views1 answer
Python mysql query to dataframe
SQL
0 vote136 views1 answer
Sql database connectivity
SQL