Optimizing SQL: Simplifying Queries with Window Functions

June 1, 2020

The term “Window Functions” never really give much away in terms of the capability and various options they provide. So, it made sense to explore these and while doing so, I thought it’s worth sharing. Turns out, Window functions are quite useful and can simplify writing complicated SQL queries. When fetching data, you could fetch…
Read more