http://msmvps.com/blogs/martinpoon/archive/2006/09/21/SQL-Server-2005-ranking-functions-_2D00_-ROW_5F00_NUMBER_28002900_.aspxROW_NUMBER() is a new function that is added to the SQL Server 2005 T-SQL syntax. ROW_NUMBER() is used to assign ranks to the result of a query. The basic syntax is ROW_NUMBER() OVER ([&lt;partition_by_clause&gt;]&lt;order_by_clause&gt;) Here comes theenCommunityServer 2008.5 SP2 (Build: 40407.4157)http://msmvps.com/blogs/martinpoon/archive/2006/09/21/SQL-Server-2005-ranking-functions-_2D00_-ROW_5F00_NUMBER_28002900_.aspx#1701137Tue, 14 Jul 2009 15:05:34 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1701137Blbqjepr<p>LWwUjS </p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1701137" width="1" height="1">http://msmvps.com/blogs/martinpoon/archive/2006/09/21/SQL-Server-2005-ranking-functions-_2D00_-ROW_5F00_NUMBER_28002900_.aspx#135657Thu, 21 Sep 2006 17:07:58 GMTd67277c4-116b-43f1-b688-e9ef184ea916:135657Martin Poon [SQL Server]<p>RANK() , DENSE_RANK() and NTILE() are newly added functions in SQL Server 2005 T-SQL syntax. Another</p> <img src="http://msmvps.com/aggbug.aspx?PostID=135657" width="1" height="1">