4D v14
all_or_any_predicate
- 4D SQL Reference
-
- Syntax rules
-
- Syntax rules
- 4d_function_call
- 4d_language_reference
- all_or_any_predicate
- arithmetic_expression
- between_predicate
- case_expression
- column_definition
- column_reference
- command_parameter
- comparison_predicate
- exists_predicate
- foreign_key_definition
- function_call
- in_predicate
- is_null_predicate
- like_predicate
- literal
- predicate
- primary_key_definition
- search_condition
- select_item
- sort_list
- sql_data_type_name
- sql_name
- sql_string
- subquery
- table_constraint
- table_reference
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
FROM SALES, CUSTOMERS
WHERE SALES.Customer_ID = CUSTOMERS.Customer_ID
AND Total_value > ALL (SELECT MAX (Total_value)
FROM SALES
WHERE Product_type = 'Software');
Product: 4D
Theme: Syntax rules
arithmetic_expression
predicate
subquery
4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)
