在业务中与见一个占比情况,做了一个小demo,以供自己参考
元数据:
实现的形式
#方式一
with demo as (
select cookieid as cookieid,
pv as pv,
sum(pv) over() as total,
pv/sum(pv) over() percent
from pv_web
)
select cookieid,sum(pv),concat(round(sum(percent)*100,2),'%') from demo group by cookieid
#方式二
select s2.cookieid,s2.aa,sum(s2.aa) over() as bb
from(
select s1.cookieid,sum(s1.pv) as aa
from pv_web s1
group by s1.cookieid
) s2
#方式三:
with demo as (
s