:::: MENU ::::

Ranking functions in SQL Server 2005 T-SQL

  • Nov 10 / 2008
  • 0
dbDigger, Ranking Functions, T-SQL Enhancements

Ranking functions in SQL Server 2005 T-SQL

Ranking functions are introduced in SQL Server 2005. There are four ranking functions introduced in SQL Server 2005. Ranking functions are non deterministic in nature. Ranking functions can be used for tasks like generating sequential numbers, creation of arrays etc. Ranking functions use ‘partition by’ and ‘order by’ clauses. It is important to note that ‘order by’ clause is not optional while using Ranking functions.

Consult us to explore the Databases. Contact us