Using Ranking and Windowing Functions in SQL Server 2005. See it here.
Page rendered at Saturday, February 27, 2021 2:15:26 PM (Eastern Standard Time, UTC-05:00)
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.