A Guide to Using Window Functions in BigQuery

Create running totals, moving averages and rankings with ease in BigQuery.

Photo by Benjamin Voros on Unsplash

If you’ve ever searched for or stumbled upon something like ‘6 SQL skills you need to know to ace that interview’ or perhaps ‘SQL concepts I wish I knew years ago’. Chances are, window functions get their well-deserved mention somewhere in that list.