Why does SUM look broken for window functions?
TL;DR: SUM is NOT broken A quandary from a work colleague this morning about rolling totals via the SUM aggregation
TL;DR: SUM is NOT broken A quandary from a work colleague this morning about rolling totals via the SUM aggregation
As most of us know, with LAG and LEAD or more generally, any analytic function that may extend “past” the
I’ve been doing a series on Analytics here but if you need to group data into ranges, you don’t necessarily
Analytic functions still bamboozle many SQL practitioners out there. So I’m building a suite of videos to walk people through
Video 2: Ranking rows https://livesql.oracle.com/apex/livesql/s/ch1tefsz0mc75pk4ix2jbfja7 Video 3: More options for ranking rows https://livesql.oracle.com/apex/livesql/s/clebs8f5n4kr2b3vjvnvvgxkn Video 4: Using the Tabibitosan method for