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 vote387 views1 answer
Postegresql update to null
SQL
0 vote369 views1 answer
Sql tablo sp
SQL
0 vote368 views1 answer
Sql developer connect to sql server
SQL
0 vote375 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote408 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote363 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote320 views1 answer
Select mysql limit to 2 decimal places
SQL
6 votes414 views6 answers
Rename column postgres
SQL
0 vote341 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
1 vote357 views1 answer
Sqlite create index
SQL