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

2 votes303 views1 answer
Oracle generated column
SQL
1 vote298 views1 answer
Sql group by sum with condition
SQL
1 vote276 views1 answer
How to truncate a table in databse
SQL
4 votes315 views6 answers
List all tables in postgres
SQL
0 vote282 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote280 views1 answer
Install postgresql 12 on debian 10
SQL
3 votes302 views1 answer
Laravel database Using Named Bindings
SQL
3 votes272 views1 answer
Show index table
SQL
1 vote287 views1 answer
Alter constraint postgres
SQL
1 vote295 views1 answer
How to see which columns are indexxed mysql
SQL