10 lines
279 B
Text
10 lines
279 B
Text
create or replace function modal_values(lst) as table (
|
|
with cte as (
|
|
SELECT number, COUNT(*) as frequency
|
|
FROM (SELECT unnest(lst) as number)
|
|
GROUP BY number )
|
|
select number
|
|
from cte
|
|
where frequency = (SELECT MAX(frequency) FROM cte)
|
|
order by number
|
|
);
|