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 vote215 views1 answer
Postgresql cast as year and month from timestamp
SQL
1 vote191 views1 answer
Foreign key constraint in ms sql
SQL
5 votes213 views2 answers
Postgres update with if condition query
SQL
1 vote215 views1 answer
Mysql event last execution
SQL
5 votes229 views6 answers
In operator sql
SQL
0 vote203 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
1 vote194 views1 answer
Select statement to print longest name
SQL
1 vote207 views1 answer
Float precision in psql
SQL
0 vote208 views2 answers
Postgres show current role
SQL
0 vote192 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL