Posts

GROUP BY vs Window Functions in SQL

Using Window Functions Instead of Aggregate Functions in SQL CASE Statements

Advantages of CTE

RANK VS DENSE_RANK VS ROW_NUMBER