Function specifications

functions Rather than selecting individual rows from a table, you can have Rim perform simple tallies on columns. The general form of the function "select" is  <"select" 〈<column>〉 <function>"("<column> 〈...〉")" 〈...〉 "from" <table> where the functions may be  <"num() sum() ave() max() " or " min()" each with an obvious functionality. Only one detail column may be specified. If it is omitted the selection will produce a single tally for the table. Functions will always completely disregard any missing values.


0=select symbol m_c:name num(resistivity) +
        ave(resistivity@f9.2) from measures =
=24pc

 symbol    name          NUM(resistivity )  AVE(resistivity )
 --------  ------------  -----------------  -----------------
 Al        Aluminum             2               13.65
 Cu        Copper               3               12.27
 Fe        Iron                 1               19.40
\fbox{\parbox{355pt}{\vspace{1ex}
{\tt\begin{tabular}{l}\the\toks0\end{tabular}...
...ex}
\makebox[355pt]{\hfill\fbox{\fbox{\box\Rimdemobox}}\hskip1ex}\vspace{1ex}}}