The SQL window functions are covered in this video with lots of examples.

The SQL window functions are covered in this video with lots of examples including RANK, DENSE_RANK, NTILE, ROW_NUMBER, CUME_DIST, LEAD, LAG, PERCENTILE_CONT, PERCENTILE_DISC, FIRST_VALUE, LAST_VALUE, PERCENT_RANK. These functions are demonstrated in the context of areas, countries, and total sales so that a good understanding of how to use these functions is obtained.