Size: a a a
DT
K
P
K
S
DK
НМ
D
name
1
1
1
1
1
2
2
2
3
3
name count percent
1 5 50
2 3 30
3 2 20
SELECT
name,
count() AS count,
round(count * 100.0 / (
SELECT count()
FROM table
), 3) AS percentage
FROM table
GROUP BY name
ORDER BY count DESC;
select
arrOut.1 as n,
arrOut.2 as cnt,
arrOut.3 as pctcnt
from
(
select groupArray((n,cnt)) as arr,
arrayReduce('sum', arr.2) as totalcnt,
arrayMap(x-> (x.1, x.2, x.2/totalcnt*100), arr) as arrOut
from (
select n, count() as cnt from (
select arrayJoin([1,1,1,1,2,2,2,3,3]) as n
)
group by n
)
) array join arrOut
P
K
K
K
МЮ
МЮ
S
S
clickhouse-client --help |grep database | head -1
-d [ --database ] arg database
P🐈
МЮ
clickhouse-client --help |grep database | head -1
-d [ --database ] arg database
GZ
И
