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

18 votes116 views6 answers
Drop table if exists
SQL
8 votes135 views4 answers
Convert date to dd/mm/yyyy sql
SQL
7 votes123 views2 answers
3rd height salary sql
SQL
0 vote117 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote104 views1 answer
Alter column to not null with default value sql server
SQL
0 vote135 views3 answers
Join
SQL
0 vote124 views1 answer
Login failed for login due to trigger execution
SQL
-1 vote111 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote143 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
4 votes132 views1 answer
Postgresql create table with index
SQL