WHERE Clause
WHERE Clause
A where clause is used to filter columns by a search condition.
Syntax
<where clause> ::= WHERE <search condition>. |
The result of the <where clause> is a result table consisting of the set of rows for which the evaluation of the <search condition> yields true.
No <set function> shall be specified in a <where clause>.
More Information