sql 开窗函数的用法

-- 若看不懂就百度一下
<窗口函数> over (
partition by<用于分组的列名>
order by<用于排序的列名>
)
-- rank dense_rank rank
rank() over(partition by col1 order by col2)
dense_rank() over(partition by col1 order by col2)
row_number() over(partition by col1 order by col2)

-- sum count avg max min 
sum(col3) over(partition by col1 )  -- 分组聚合
sum(col3) over(order by col2 )      -- 累计聚合
sum(col3) over(partition by col1 order by col2 ) -- 累计分组集合