Home > IT Answers > Oracle > row_number in sql 2000
Rl
10 pts.
 row_number in sql 2000
ROW_NUMBER, SQL Query, SQL Server 2000
how to find out the row_number in sql 2000 like using row_number() function in sql 2005

Software/Hardware used:
ASKED: May 8, 2008  10:51 PM
UPDATED: March 11, 2010  9:12 PM
RELATED QUESTIONS
Answer Wiki:
well i would prefer adding a simple running counter using php (or whatever you're using) on demand but it is also possible to go at it like this, <a href="http://support.microsoft.com/default.aspx/kb/186133">kb186133</a>, i guess...
Last Wiki Answer Submitted:  May 9, 2008  3:24 pm  by  Santa   35 pts.
All Answer Wiki Contributors:  Santa   35 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 
msi77
 1,610 pts.