Condition Clause

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks >

Condition Clause

Previous pageReturn to chapter overviewNext page

Referenced by:

SELECT clauses: HAVING, WHERE, and JOIN conditions. (See also the SELECT chart and its subcharts.)
DELETE
CREATE VIEW

A condition is any value expression of type BOOLEAN, such as the following examples:

2<4
TRUE
FALSE
expr_17 IS NULL
NOT expr_19 IS NULL AND expr_23 < expr>29
expr_17 IS NULL OR ( NOT expr_19 IS NULL AND expr_23 < expr>29 )