Search Condition

Search conditions are used in the WHERE clause, HAVING clause and the ON conditions of the Joined Table. They are used to filter results of queries or to determine the evaluation of joins. Search conditions follow a three valued logic. The result of a search condition is true, false or unknown. A search condition is either a predicate or a complex Boolean expression of multiple search conditions.

Syntax Syntax

<search condition> ::= <predicate>
                                  | <boolean expression>. 

<predicate> ::= <comparison predicate> 
                      | <quantified comparison predicate> 
                      | <between predicate> 
                      | <in predicate> 
                      | <like predicate> 
                      | <null predicate> 
                      | <exists predicate>.

End of the code.

Example

Syntax Syntax

SELECT * FROM a WHERE NOT ( c < 1 ) AND c <= 100

End of the code.

This SELECT yields all rows from table a where the value of the column a.c not lower than 1 and lower or equal to 100.

More Information

Comparison predicate

Quantified comparison predicate