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

5 votes287 views6 answers
Sql foreign key
SQL
0 vote308 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
1 vote281 views1 answer
Postgresql delete cascade
SQL
0 vote279 views1 answer
Php select data from mysql database without column name
SQL
0 vote240 views2 answers
Postgresql could not start server mac
SQL
0 vote281 views1 answer
Exclude last comma separated string mysql
SQL
1 vote292 views1 answer
Create new index takes long time postgresql
SQL
0 vote267 views1 answer
Query on date sqlite flutter
SQL
0 vote268 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote244 views1 answer
Check sql query executed wp
SQL