Browse by Tags

All Tags » pagination (RSS)

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...