聚集类:count/sum/max/min
行号:row_number()over(partition by deptno order by empno)
等级:dense_rank()over(order by age)
取上下行值:lag/lead
lag(deptno)over(order by deptno)
桶函数:ntile(4)over(order by empno)
聚集类:count/sum/max/min
行号:row_number()over(partition by deptno order by empno)
等级:dense_rank()over(order by age)
取上下行值:lag/lead
lag(deptno)over(order by deptno)
桶函数:ntile(4)over(order by empno)