sql开窗函数聚合、排序、分组

1、聚合sum avg max min等

select   id,sum(销量) over() as 销量 from 业绩表

2、排序row_number()、dense_rank()、rank()

--select *,row_number() over(partition by id order by email ) r from cs --分组排序
--select email,dense_rank() over(order by email asc) r from cs --连续排序
--select email,rank() over(order by email asc) r from cs --跳跃排序

3、分组ntile

select order,ntile(3) over (order by order) from ss