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

3 votes148 views2 answers
Truncate table
SQL
1 vote151 views1 answer
Add multiple row table pl sql
SQL
5 votes150 views1 answer
Oracle list days between two dates
SQL
6 votes148 views1 answer
SQL insert all columns
SQL
0 vote173 views2 answers
Search stored procedures by name
SQL
1 vote153 views1 answer
Top 10 rows in mysql
SQL
0 vote131 views1 answer
Oracle locked objects
SQL
0 vote141 views1 answer
Create table database in psql
SQL
0 vote135 views2 answers
Mysql create table if not exists
SQL
1 vote137 views1 answer
Window function mysql
SQL