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 vote123 views1 answer
How to see password mysql vestacp
SQL
0 vote83 views1 answer
Procedures and functions in pl/sql
SQL
0 vote82 views1 answer
Alter session set nls_language french
SQL
0 vote127 views1 answer
Where date in datetime mysql
SQL
0 vote163 views3 answers
Select top 10 rows in sql
SQL
0 vote145 views1 answer
How to get button for every record from mysql
SQL
11 votes126 views4 answers
MYSQL LOGIN
SQL
1 vote134 views2 answers
Sql server concat string and int
SQL
0 vote123 views1 answer
Oracle job class
SQL
8 votes149 views3 answers
Find table for column name in sql
SQL