Anonymous user
Averages/Mode: Difference between revisions
Added SQL implementation
(Added SQL implementation) |
|||
Line 2,897:
mode displayNl.</lang>
=={{header|SQL}}==
Some databases have a built-in function. In Oracle you can say <code>select stats_mode(val) from...</code> but that returns one value, so doesn't handle non-unique modes. Other databases don't have a built-in. So here's a way to do this in a query.<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 (1);
insert into averages values (2);
insert into averages values (4);
insert into averages values (2);
insert into averages values (5);
insert into averages values (2);
insert into averages values (3);
insert into averages values (3);
insert into averages values (1);
insert into averages values (3);
insert into averages values (6);
-- find the mode
with
counts as
(
select
val,
count(*) as num
from
averages
group by
val
)
select
val as mode_val
from
counts
where
num in (select max(num) from counts);</lang>
{{out}}
<pre> MODE_VAL
----------
2
3</pre>
=={{header|Tcl}}==
{{works with|Tcl|8.6}}
| |||