一个例子:
select distinct application_id,count(1) over (partition by application_id),
count(1) over (),count(1) over (partition by application_id)/count(1) over ()
from
ipop_admin.ipop_worktype_lkp where application_id between 0 and 10
or
with t1 as (select count(*) n1 from ipop_admin.ipop_worktype_lkp )
select application_id,count(*)/(n1) pct from ipop_admin.ipop_worktype_lkp,t1 group by application_id,n1