TL;DR

Learn to perform advanced calculations with ROW_NUMBER, RANK, PARTITION BY, LAG, LEAD, and running totals

Key concepts

  • SQL window functions
  • ROW_NUMBER
  • PARTITION BY

Next lesson

Database Design

Learn database design with normalization, entity-relationship modeling, primary and foreign keys, and constraints for clean schemas.

28 min

Also learn

TypeScriptMaster TypeScriptJavaScriptMaster JavaScript ProgrammingRustMaster Rust ProgrammingPHPMaster PHP Web Development