ms sql server 2012 how to use the ranking functions demo

In this demo, we will learn how to use the ranking function to select top(X) rows for multiple categories in a single query in MS SQL Server 2012.