Code24Lab
Menu
Courses Categories Guides Pricing Log in Sign up

LAG and LEAD: Comparing with the Previous Row

Lesson 4 of 21 Lab 🔒 Locked

Lessons in this course

  1. ROW_NUMBER(): Numbering Rows Without Losing ThemLabFree
  2. PARTITION BY: Top-N per GroupLab Locked
  3. RANK, DENSE_RANK and ROW_NUMBER on TiesLab Locked
  4. LAG and LEAD: Comparing with the Previous RowLab Locked
  5. Running Totals with SUM() OVERLab Locked
  6. Window Frames: Moving Averages with ROWS BETWEENLab Locked
  7. ROWS vs. RANGE: The Default Frame TrapLab Locked
  8. Partition Totals and Shares Without GROUP BYLab Locked
  9. NTILE, PERCENT_RANK and CUME_DISTLab Locked
  10. FIRST_VALUE, LAST_VALUE and the Frame TrapLab Locked
  11. Gaps and Islands: Finding StreaksLab Locked
  12. Recursive CTEs: Generating a SeriesLab Locked
  13. Recursive CTEs: Walking a HierarchyLab Locked
  14. Index Selectivity and Optimizer StatisticsLab Locked
  15. B-tree Height and the Index vs. Scan DecisionLab Locked
  16. Composite Indexes and the Leftmost-Prefix RuleLab Locked
  17. Sargable Predicates and Date RangesLab Locked
  18. Join Algorithms: Nested Loop vs. Hash JoinLab Locked
  19. Normalisation: Redundancy, Anomalies and SizeLab Locked
  20. Transactions, Lost Updates and Isolation LevelsLab Locked
  21. Final Project: A Regional Revenue ReportLab Locked