|
search_condition
|
|
|---|---|
|
search_condition
|
::= search_item | search_item { AND | OR } search_item
|
|
search_item
|
::= [NOT] { search_test | ( search_condition )}
|
|
search_test
|
::= comparison_test | between_test | like_test | null test | set_test | quantified_test | existence_test
|
|
comparison_test
|
::= expression { = | <> | < | <= | > | >= } { expression | subquery }
Note Spaces on each side of the operator are optional.
|
|
between_test
|
::= column_identifier [NOT] BETWEEN expression AND expression
|
|
like_test
|
::= column_identifier [NOT] LIKE value [ESCAPE value]
|
|
null_test
|
::= column_identifier IS [NOT] NULL
|
|
set_test
|
::= expression [NOT] IN ( { value [, value ]... | subquery } )
Note If the IN clause contains only one item, parenthesis are not needed. ::= expression [NOT] IN value
For example:
SELECT * FROM MY_TABLE1 WHERE A IN 2; SELECT * FROM MY_TABLE1 WHERE A IN (2,3,6);
|
|
quantified_test
|
::= expression { = | <> | < | <= | > | >= } [ALL | ANY | SOME] subquery
|
|
existence Jest
|
::= EXISTS subquery
|