Window Functions – Making Your SQL Life Easier
SQL window functions have been around for some time now (they were part of the SQL 2003 ISO standard). However, adoption has taken time in some database systems. For example, they weren’t introduced in MySQL until MySQL 8 (2018). Window functions are functions that aggregation data, but are returned to the un-aggregated row. For example, … Read more