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 vote212 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote233 views1 answer
How to login to mysql in homestead
SQL
0 vote212 views10 answers
John the ripper mysql
SQL
0 vote245 views1 answer
Sqlite3_open_v2
SQL
5 votes242 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
1 vote239 views1 answer
Oracle drop job if exists
SQL
0 vote231 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
1 vote242 views1 answer
Postgres set sequence value to max id
SQL
1 vote216 views2 answers
Mysql type conversion
SQL
0 vote285 views1 answer
Postgres extract number from string
SQL