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 vote198 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote230 views1 answer
Postgresql auto increment not working
SQL
1 vote214 views1 answer
Mysql get latest duplicate rows
SQL
15 votes211 views2 answers
How to know the username of postgresql
SQL
0 vote205 views2 answers
Postgresql create role
SQL
19 votes205 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
1 vote202 views2 answers
Pl sql case
SQL
0 vote228 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote217 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote214 views1 answer
How to write triggers to increment or decrement the number of employees
SQL