What is ROW_NUMBER function? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

What is ROW_NUMBER function?

Author

Topic

ynevet
Starting Member

10 Posts

Posted - 2010-03-03 : 10:25:06

Hi,

What does it is returning?

Yair

Yair

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-03-03 : 10:30:47

It is one type of ranking function.
This function returns a sequential number starting at 1 for each row or grouping within your result set.

For more details refer the below link

http://www.databasejournal.com/features/mssql/article.php/3661461/New-Ranking-Functions-within-SQL-Server-2005.htm

Regards,
Bohra

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-03 : 10:51:52

see

http://msdn.microsoft.com/en-us/library/ms189461.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources