Row_Number

This article explains about the Row_Number function in SQL Server 2005. It explains whether SQL Server 2005 Row_Number function will support SubQueries or not. Introduction SQL Server 2005 have introduced new function  ROW_NUMBER to find the Row number of a particular column if its specified in orderby Clause The syntax for RowNumber is, SELECT ROW_NUMBER … Row_Number function in SQL Server 2005