Oracle中如何求分组数据的百分数？

一个例子：

 

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