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
Tag: analytics
LAG / LEAD quick tip
As most of us know, with LAG and LEAD or more generally, any analytic function that may extend “past” the
Histograms on data (not the optimizer)
I’ve been doing a series on Analytics here but if you need to group data into ranges, you don’t necessarily
KISS video series for Analytic functions
Analytic functions still bamboozle many SQL practitioners out there. So I’m building a suite of videos to walk people through
Analytics Demo Scripts
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
