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 vote280 views1 answer
My sql data file extention
SQL
0 vote274 views1 answer
Mssql view column data type
SQL
0 vote285 views1 answer
Sql script get all stored procedures from database
SQL
3 votes250 views1 answer
Oracle wait
SQL
7 votes229 views1 answer
Alter table add key sql
SQL
1 vote270 views1 answer
Postgres select as csv
SQL
0 vote283 views1 answer
How to search query in python3 sqlite3
SQL
1 vote273 views1 answer
Mysql check table exists
SQL
0 vote279 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote267 views1 answer
Oracle date summer time
SQL