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.

This article was originally published in the October 2018 issue of php[architect] magazine. To read the complete article please subscribe or purchase the complete issue.

Related Articles

Leave a comment

Use the form below to leave a comment: