This article explains SQL window functions ROW_NUMBER, RANK, and DENSE_RANK. It provides examples and syntax for each function and explains how to handle ties and gaps in ranking. The article also ...

It is a SQL practice repository covering basics to advanced topics. It includes exercises on SELECT statements, WHERE clauses, GROUP BY, JOINS, window functions (OVER(), PARTITION BY), ROW_NUMBER(), ...