4D v19
search_condition
- 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
search_condition
|
NOT search_condition | (search_condition) | search_condition OR search_condition | search_condition AND search_condition | |
||
A search_condition specifies a condition to be applied to the data retrieved. A combination of search conditions using AND or OR keywords can also be applied. You can also precede a search_condition with the NOT keyword in order to retrieve data that does not meet the specified condition.
It is also possible to pass a predicate as a search_condition.
Here is an example using a combination of search conditions in the WHERE clause:
SELECT supplier_id
FROM suppliers
WHERE (name = 'CANON')
OR (name = 'Hewlett Packard' AND city = 'New York')
OR (name = 'Firewall' AND status = 'Closed' AND city = 'Chicago');
Produkt: 4D
Thema: Syntax rules
4D - SQL Reference ( 4D v19)
