问在所有r中选择dense_rank()和MAX (dense_rank() )

EN

with claims as (
select dense_rank() over(order by A.claim_id) as "Claim Count", 
A.person_cpr as "Unique member ID" 
from my_table as A
)
select "Claim Count", "Unique member ID", 
   max("Claim Count") over (partition by "Unique member ID") as "Max Claim Count"
from claims;