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

1 vote257 views1 answer
Mysql random limit 1
SQL
0 vote256 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
1 vote271 views1 answer
Hexadec to sql REDSHIFT
SQL
0 vote267 views1 answer
Oracle temporary table
SQL
0 vote291 views1 answer
SQLServerException.makeFromDatabaseError
SQL
2 votes279 views1 answer
Sql OR
SQL
0 vote268 views1 answer
Mysql multiple group by
SQL
0 vote223 views1 answer
Mysql find foreign key references
SQL
0 vote247 views2 answers
Avg() sql
SQL
0 vote276 views1 answer
Close sql query vb.net
SQL