PHP Architect · Vol 17, Issue 10 · October 2018
SQL Windowing Functions
by Dave Stokes
Structured Query Language, or SQL, was a boring, ho-hum declarative programming language for many years until the fairly recent additions of common table expressions and windowing functions. CTEs and windowing functions turn SQL into a much more robust programming language which provides increased power for your SQL queries. Most popular databases have them and as you will see windowing functions provide some amazing capabilities for data analytics.
The full article is in PHP Architect Vol 17, Issue 10. Subscribe to read it and every new issue.
