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 vote126 views1 answer
FIND most frequent word in sql server
SQL
21 votes135 views3 answers
Sql server search column name in all tables
SQL
0 vote125 views1 answer
Insert or update sql query
SQL
0 vote122 views1 answer
First mysql
SQL
5 votes141 views4 answers
Change auto increment mysql
SQL
0 vote131 views1 answer
How to import sqlite driver class in java using maven
SQL
7 votes214 views1 answer
Oracle alter sequence restart start with
SQL
0 vote143 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
3 votes147 views2 answers
Sqlite show table definition
SQL
0 vote144 views1 answer
SQL get max per id
SQL