Lesson 9 of 25 · Beyond SELECT

SQL Window Functions — RANK, DENSE_RANK, LEAD and LAG

Window functions are the dividing line between basic SQL and useful SQL — running totals, rankings and comparisons to the previous row, all without leaving the query. Twenty-five minutes very well spent.

Video not playing? Some channels disable embedding, and there is no way around it.Open on YouTubeinstead — then come back and mark it complete.