你能做到吗？我不熟悉巴巴拉斯的语法。如果这样做的话，它会更简洁更好。

select specialization, count(distinct claim_id) AS Claim_Totals, count(distinct claim_id)/total_claims
from table1 
INNER JOIN ( SELECT COUNT(DISTINCT claim_id)*1.0000 total_claims AS total_claims 
               FROM table1 ) TMP
   ON 1 = 1
group by specialization
order by Claim_Totals DESC

select specialization, 
       count(distinct claim_id) AS claim_by_spec,
       count(distinct claim_id)/
       ( SELECT COUNT(DISTINCT claim_id)*1.0000
               FROM table1 ) AS percentage_calc
from table1 
group by specialization
order by Claim_Totals DESC

因为你正在使用 count(distinct) ，窗口函数不太有用。您可以尝试：

select t1.specialization,
       count(distinct t1.claim_id) AS Claim_Totals,
       count(distinct t1.claim_id) / tt1.num_claims
from table1 t1 cross join
     (select count(distinct claim_id) as num_claims
      from table1
     ) tt1
group by t1.specialization
order by Claim_Totals DESC

你可以用 ,concat_ws('',count(distinct claim_id),'%') as percentage 或 ,concat(count(distinct claim_id),'%') as percentage 添加到选择列表的尾部
顺便说一句， distinct 在专门化之前，选择列表是多余的，因为已经包含在groupby列表中。

你可以用 sum(count(distinct)) over() 得到总体索赔，并在分母中使用它来得到百分比。

select specialization
      ,count(distinct claim_id) AS Claim_Totals
      ,round(100*count(distinct claim_id)/sum(count(distinct claim_id)) over(),3) as percentage
from table1
group by specialization