Use of RANK() and Partition by clause in SQL-Server 2005

Use of RANK() and Partition by clause in SQL-Server 2005
We will start by creating one table for demonstration and enter some records in it.
This blog is moved to “Extreme-Advice.com“, to read this post, kindly click here.