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

4 votes164 views2 answers
Sql table
SQL
-1 vote175 views1 answer
Concat two columns in sql server
SQL
13 votes228 views3 answers
Mysqldump structure only
SQL
0 vote170 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
1 vote137 views2 answers
Delete auto increment mysql
SQL
17 votes183 views5 answers
Order by sql
SQL
0 vote167 views1 answer
Nueva tabla mysql
SQL
0 vote173 views1 answer
Show table details postgresql
SQL
3 votes237 views3 answers
Restart mysql mac
SQL
35 votes182 views6 answers
Postgres
SQL