T-SQL by Example

🚧 Window Basics

🚧 Coming soon: Ranking within partitions and ordering nuances.

-- Placeholder example
SELECT o.*, ROW_NUMBER() OVER (PARTITION BY CustomerID ORDER BY OrderDate DESC) AS rn
FROM dbo.Orders o;