Ansicht
Dokumentation

ABENSQL_COND_SYNTAX - SQL COND SYNTAX

... ${ ${operand1 ${=$|EQ$|<>$|NE$|>$|GT$|$|LT$|>=$|GE$|=$|LE$}
                  ${ operand2
                  $| ${$[ALL$|ANY$|SOME$] ( SELECT subquery $[UNION ...$] )$} $}$}
    $| ${operand $[NOT$] BETWEEN operand1 AND operand2$}
    $| ${operand1 $[NOT$] LIKE operand2 $[ESCAPE esc$]$}
    $| ${operand IS $[NOT$] NULL$}
    $| ${operand IS $[NOT$] INITIAL$}
    $| ${EXISTS ( SELECT subquery $[UNION ...$] )$}
    $| ${operand $[NOT$] IN (operand1, operand2 ...)$}
    $| ${operand $[NOT$] IN ( SELECT subquery $[UNION ...$] )$}
    $| ${( operand1, operand2, ... ) IN ( ( operand11, operand21 ... ),
                                        ( operand12, operand22 ... ), ... )$}
    $| ${operand $[NOT$] IN @range_tab$}
    $| ${(cond_syntax)$} $} ...