4D v13.4all_or_any_predicate |
||||||||||||||
|
4D v13.4
all_or_any_predicate
all_or_any_predicate
An all_or_any_predicate is used to compare an arithmetic_expression with a subquery. You can pass comparison operators like <, <=, =, >=, > or <> as well as the ANY, ALL and SOME keywords along with the subquery to be used for comparison. This example carries out a subquery which selects the best software sales. The main query selects records from the SALES and CUSTOMERS tables where the Total_value column is greater than the records selected by the subquery: SELECT Total_value, CUSTOMERS.Customer |
PROPERTIES
Product: 4D INDEX SEE ALSO
arithmetic_expression |
||||||||||||