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 votes153 views1 answer
Sqlite show table indexes
SQL
1 vote162 views1 answer
Mysql get latest duplicate rows
SQL
0 vote240 views1 answer
Mysql grant access to one database
SQL
1 vote145 views1 answer
Error code 1175 mysql fix
SQL
0 vote147 views2 answers
Raise notice in postgresql function
SQL
0 vote149 views1 answer
Sql date d'aujourd'hui
SQL
1 vote171 views1 answer
How to see which columns are indexxed mysql
SQL
-2 votes160 views2 answers
Sqlserver docker
SQL
0 vote150 views1 answer
Postgresql update to unique
SQL
1 vote169 views1 answer
Sql first
SQL