Emulating Analytic (AKA Ranking) Functions with MySQL (O'ReillyNet)

[Posted March 29, 2007 by cook]

Stéphane Faroult discusses the emulation of analytic functions in MySQL on O'Reilly. "One of the most hailed extensions brought to SQL in recent years has been these functions that Oracle calls analytic functions, DB2 calls OLAP functions, and SQL Server 2005 calls ranking functions--but which MySQL, so far, still lacks. The good news is that they can be (relatively) easily and efficiently emulated."