On Thu, 22 Feb 2007, miguel manese wrote:
Best example using your particular case is Igor's answer:
select cat, pos, avg(col1), avg(col2), ...
from voting
group by cat, pos;
Thank you, Miguel.
Rich
--
Richard B. Shepard, Ph.D. |The Environmental Permitting
Applied Eco
On 2/22/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
However, I'm stuck on the proper SQL syntax. A nudge in the right
direction -- including pointers to the appropriate documentation -- would be
much appreciated.
The "rule of thumb" is that anything that appears in the group-by
clause can app
I have a table, 'voting,' with 31 columns. For each of 28 REAL columns I
need to calculate averages both by groups and total. I tried:
sqlite> select AVG(pos) from voting where cat = 'eco';
and 0.0 was returned. Before this I tried combinations that were
syntactically incorrect; e.g.,
sqlite>
3 matches
Mail list logo
