常用开窗函数

ROW_NUMBER() OVER(PARTITION BY ... ORDER BY ...)
RANK() OVER(PARTITION BY ... ORDER BY ...)
DENSE_RANK() OVER(PARTITION BY ... ORDER BY ...)
COUNT() OVER(PARTITION BY ... ORDER BY ...)
MAX() OVER(PARTITION BY ... ORDER BY ...)
MIN() OVER(PARTITION BY ... ORDER BY ...)
SUM() OVER(PARTITION BY ... ORDER BY ...)
AVG() OVER(PARTITION BY ... ORDER BY ...)
FIRST_VALUE() OVER(PARTITION BY ... ORDER BY ...)
LAST_VALUE() OVER(PARTITION BY ... ORDER BY ...)
LAG() OVER(PARTITION BY ... ORDER BY ...)
LEAD() OVER(PARTITION BY ... ORDER BY ...)

常用开窗函数

原文：https://www.cnblogs.com/WaitSani/p/13194270.html