SQL Explained: Ranking Analytics. What they are and how you use them | by Thomas Reid | Jun, 2024

What they are and how you use them

If you have experience with one of the popular RDBMS management systems like Oracle, SQL Server, Postgres etc., you might at some stage have come across analytic, sometimes referred to as windowing, functions.

Analytics allow you to calculate aggregates and ranking sequences for groups of rows within your dataset. If you’ve…