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 vote122 views1 answer
How to to get current date and time in sql
SQL
0 vote137 views1 answer
Mysql get longest string in column
SQL
0 vote148 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
2 votes154 views1 answer
Oracle kill session by sql_id
SQL
0 vote147 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote162 views1 answer
Plpgsql create function
SQL
0 vote130 views1 answer
Get employees if not contains in sql
SQL
0 vote130 views1 answer
Find usage of table in sql server
SQL
11 votes136 views2 answers
Having clause in sql
SQL
21 votes134 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL