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