interviews.dotnetthread.com

↑ Grab this Headline Animator

Monday, June 2, 2008

What is ROW_NUMBER function in T-SQL?

ROW_NUMBER is a new function in T-SQL which is introduced in SQL Server 2005. Basically, it returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition. It is very similar to the ROWNUM function in Oracle

Submit this story to DotNetKicks

No comments:

Post a Comment

Post your comments/questions/feedback for this Article.

 

Latest Articles