Where clause

where@<where clause> The "where" clause acts as a filter which passes only those rows that pass the clause criteria. For example,  <"select" <columns> "from measures where symbol='Cu'" selects only the measurements of copper (Cu) and ignores the other rows. The "where" clause consists of


\begin{List} % latex2html id marker 461\item[comparisons] of the form \<<col... ...; op_b\; C_3)$& $C_2\; op_b\; C_3$, then $ C_1\; op_a$ \end{tabular}\end{List}


0=select symbol m_c:name resistivity@f7.2 from measures +
        where symbol='Cu' ==24pc

 symbol    name          resistivity
 --------  ------------  ------------
 Cu        Copper          11.90
 Cu        Copper          12.40
 Cu        Copper          12.50
\fbox{\parbox{355pt}{\vspace{1ex} {\tt\begin{tabular}{l}\the\toks0\end{tabular}... ...ex} \makebox[355pt]{\hfill\fbox{\fbox{\box\Rimdemobox}}\hskip1ex}\vspace{1ex}}}