Anonymous user
Averages/Pythagorean means: Difference between revisions
Added SQL implementation
No edit summary |
(Added SQL implementation) |
||
Line 3,037:
H(1,...,10) = 3.414171521474055006096734859775098225173</pre>
=={{header|SQL}}==
It may not be possible to calculate a geometric mean in a query, but the other two are easy enough.
<lang sql>
--setup
create table averages (val integer);
insert into averages values (1);
insert into averages values (2);
insert into averages values (3);
insert into averages values (4);
insert into averages values (5);
insert into averages values (6);
insert into averages values (7);
insert into averages values (8);
insert into averages values (9);
insert into averages values (10);
-- calculate means
select
1/avg(1/val) as harm,
avg(val) as arith
from
averages;
</lang>
{{out}}
<pre>
HARM ARITH
---------- ----------
3.41417152 5.5
</pre>
=={{header|Smalltalk}}==
{{works with|GNU Smalltalk}}
| |||