SQL Server Window Functions The CUME_DIST example contains explanations relevant to all window functions CUME_DIST DENSE_RANK FIRST_VALUE LAG LAST_VALUE LEAD PERCENT_RANK RANK ROW_NUMBER < BACK | HOME