Simulate ROW_NUMBER in SQL 2000
Posted
by Derek Dieter
on SQL Server Planet
See other posts from SQL Server Planet
or by Derek Dieter
Published on Sun, 23 May 2010 08:51:21 +0000
Indexed on
2010/05/23
8:52 UTC
Read the original article
Hit count: 483
Filed under:
SQL Server 2000
While the row_number feature in sql 2005+ has proven to be a very powerful feature, there are still ways to implement that same functionality in SQL Server 2000. Let’s first look at the SQL 2005+ implementation of ROW_NUMBER, then compare it to the SQL 2000:-- SQL 2005+ SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY c.LastName ASC) ,c.LastName ,c.FirstName FROM [...]
© SQL Server Planet or respective owner
