WHERE Clause
WHERE Clause
A where clause is used to filter columns by a search condition.
<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>.