Search code examples
sqlrankanalytic-functions

In which SQL dialect was RANK() first introduced?

In which SQL standard was RANK() first introduced?

List of SQL standards:

  • SQL-86
  • SQL-89
  • SQL-92
  • SQL:1999
  • SQL:2003
  • SQL:2008

SQL Rank function: http://en.wikipedia.org/wiki/Select_(SQL)#RANK.28.29_window_function

References would be most appreciated.

Solution

  • The analytic features are defined as part of the ANSI SQL 1999 standard

    Reference: