1、累计统计,遇到重复行时不累加
sum(count(*)) over(order by count(*) desc )
2、累计统计,遇到重复行时也累加
sum(count(*)) over(order by count(*) desc rows between UNBOUNDED PRECEDING and current row )
1、累计统计,遇到重复行时不累加
sum(count(*)) over(order by count(*) desc )
2、累计统计,遇到重复行时也累加
sum(count(*)) over(order by count(*) desc rows between UNBOUNDED PRECEDING and current row )