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 vote311 views1 answer
Mod in sql
SQL
2 votes323 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote321 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote293 views1 answer
Mysql function variable
SQL
1 vote361 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
7 votes323 views5 answers
Sql remove spaces
SQL
12 votes291 views3 answers
Duplicate a column in sql
SQL
1 vote328 views1 answer
Sql server today minus n
SQL
0 vote285 views1 answer
Check if a word appears at the end sql query
SQL
22 votes295 views6 answers
Create sql table
SQL