SQL SQLite - 如何获得平均值？

SQLite - how to get average value?

提问by Ilya Suzdalnitski

I have in my table a column that has values of type FLOAT. How can I get average value of all elements in this column?

我的表中有一个具有 FLOAT 类型值的列。如何获得此列中所有元素的平均值？

回答by tpdi

select avg( columnname) from table;

This will average all rows. To average a subset, use a whereclause. To average for each group (of something) use a groupby clause.

这将平均所有行。要平均一个子集，请使用where子句。要平均每组（某物）使用groupby 子句。

回答by Jér?me

select avg(col1) from table;

回答by soulmerge

SELECT AVG(column) FROM ...

回答by Matthew Flaschen

select avg(column) from table;