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
whereclause. To average for each group (of something) use agroupby clause.
0 comments:
Post a Comment