Tuesday, May 3, 2011

SQLite - how to get average value?

Hi, 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?

Thank you in advance.

From stackoverflow
  • SELECT AVG(column) FROM ...
    
  • select avg(column) from table;

  • select avg(col1) from table;
    
  • select avg( columnname) from table;
    

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

0 comments:

Post a Comment