BiteSizedChunks.comLearn one small thing at a time.

Courses Suggested Paths Pricing

Course contentsShowHide

Databases & SQL

580Window functions versus GROUP BY
581OVER clause syntax
582PARTITION BY
583ORDER BY inside windows
584Window definitions with WINDOW
585Named window inheritance
586Window function evaluation order
587Filtering window results with subqueries
588Aggregate functions as window functions
589Running totals
590Moving averages
591Percent of total calculations
592Partition-wise ranking
593Windows over grouped results
594Windows and DISTINCT interactions
595Ties and peer rows
596row_number unique ordinals
597rank gap-producing ranks
598dense_rank gapless ranks
599percent_rank relative ranks
600cume_dist cumulative distribution
601ntile equal-sized buckets
602lag previous-row access
603lead next-row access
604lag default values
605first_value partition starts
606last_value frame traps
607nth_value positional access
608IGNORE NULLS and RESPECT NULLS
609Top N per group with row_number
610Deduplication with row_number
611Gaps and islands with row_number differences
612Sessionization with lag and cumulative sums
613Month-over-month growth with lag
614Year-over-year revenue comparisons
615Customer retention cohorts
616Median calculation with window functions
617Default window frame
618ROWS frames
619RANGE frames
620GROUPS frames
621UNBOUNDED PRECEDING
622N PRECEDING
623CURRENT ROW
624N FOLLOWING
625UNBOUNDED FOLLOWING
626EXCLUDE CURRENT ROW
627EXCLUDE GROUP
628EXCLUDE TIES
629EXCLUDE NO OTHERS
630Interval RANGE offsets over dates
631Centered moving averages
632Trailing seven-day averages
633Frame behavior with duplicate sort keys
634Frame start and end ordering rules
635Window sorting cost
636Combining several windows in one query
637Stock price moving average challenge
638Rolling revenue by region challenge

Databases & SQL

580Window functions versus GROUP BY
581OVER clause syntax
582PARTITION BY
583ORDER BY inside windows
584Window definitions with WINDOW
585Named window inheritance
586Window function evaluation order
587Filtering window results with subqueries
588Aggregate functions as window functions
589Running totals
590Moving averages
591Percent of total calculations
592Partition-wise ranking
593Windows over grouped results
594Windows and DISTINCT interactions
595Ties and peer rows
596row_number unique ordinals
597rank gap-producing ranks
598dense_rank gapless ranks
599percent_rank relative ranks
600cume_dist cumulative distribution
601ntile equal-sized buckets
602lag previous-row access
603lead next-row access
604lag default values
605first_value partition starts
606last_value frame traps
607nth_value positional access
608IGNORE NULLS and RESPECT NULLS
609Top N per group with row_number
610Deduplication with row_number
611Gaps and islands with row_number differences
612Sessionization with lag and cumulative sums
613Month-over-month growth with lag
614Year-over-year revenue comparisons
615Customer retention cohorts
616Median calculation with window functions
617Default window frame
618ROWS frames
619RANGE frames
620GROUPS frames
621UNBOUNDED PRECEDING
622N PRECEDING
623CURRENT ROW
624N FOLLOWING
625UNBOUNDED FOLLOWING
626EXCLUDE CURRENT ROW
627EXCLUDE GROUP
628EXCLUDE TIES
629EXCLUDE NO OTHERS
630Interval RANGE offsets over dates
631Centered moving averages
632Trailing seven-day averages
633Frame behavior with duplicate sort keys
634Frame start and end ordering rules
635Window sorting cost
636Combining several windows in one query
637Stock price moving average challenge
638Rolling revenue by region challenge

← Databases & SQL

Search the Databases & SQL glossary

Lesson 604 of 2,478·10. Window FunctionsFree lesson

lag default values

Writing your lesson…

← Previous Next lesson →

© 2026 BiteSizedChunks.com. Learn one small thing at a time.

Glossary Contact Terms of Service Privacy Policy