SQL Windowing screencast session for Cuppa Corner - rolling totals, data cleansing
- by tonyrogerson
In this 10 minute screencast I go through the basics of what I term windowing, which is basically the technique of filtering to a set of rows given a specific value, for instance a Sub-Query that aggregates or a join that returns more than just one row (for instance on a one to one relationship).…