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

31 votes143 views1 answer
Postgresql add column with constraint
SQL
0 vote150 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote156 views1 answer
Insert into Select * - NAYCode.com
SQL
6 votes147 views3 answers
Oracle all dates between two dates
SQL
9 votes174 views6 answers
Oracle substring
SQL
1 vote102 views1 answer
Pagination sql
SQL
0 vote142 views1 answer
Mariadb number format
SQL
22 votes182 views4 answers
Date format mysql
SQL
2 votes148 views1 answer
Oracle generated column
SQL
0 vote166 views1 answer
Mysql root localhost run
SQL