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 vote176 views1 answer
T sql cursor tr
SQL
0 vote172 views1 answer
Syntax for changing column size in mysql
SQL
2 votes155 views3 answers
Mysql cheat sheet
SQL
13 votes171 views6 answers
Restart postgresql
SQL
0 vote183 views1 answer
Datatables server side filter where clause
SQL
0 vote186 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote175 views1 answer
Reona
SQL
0 vote184 views1 answer
Mysql date format unix timestamp
SQL
0 vote169 views1 answer
Sql select lowest value row
SQL
0 vote184 views1 answer
Dataframe lambda elif
SQL