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 vote211 views1 answer
Mysqli_connect using prepare statement
SQL
11 votes204 views3 answers
Pl sql example
SQL
0 vote197 views1 answer
T-SQL Retry (deadlock)
SQL
8 votes187 views2 answers
Phpmyadmin default password
SQL
0 vote198 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote202 views1 answer
Dbms_output sql developer
SQL
0 vote191 views1 answer
Sql stored procedure update if parameter is not null
SQL
6 votes199 views3 answers
Date_trunc postgres
SQL
0 vote190 views1 answer
Sql common columns
SQL
-1 vote154 views1 answer
How to create script to connect to oracle database and run query
SQL