Browse by Tags

All Tags » Row number (RSS)
29 November 2008 09:28

Row_number() Function with no specific order

Row_number() function is used to generate row number to rows based on the column which is ordered What if you want to generate row number without ordering any column Here is the method (Consider Suppliers table from northwind database) 1 Assign dummy...
Posted by Madhivanan | with no comments
Filed under: , ,
27 August 2007 16:23

Multipurpose Row_Number() Function

One of the features available in SQL Server 2005 is Row_Number() function. It is not only used to generate row number for each row but also used for other purposes as well. I breifly explain how it can be used for various purposes Consider the following...
Posted by Madhivanan | 5 comment(s)
Filed under: , , ,