views:

40

answers:

1

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.

+2  A: 

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

Reference:

OMG Ponies
Thank-you. Ponies win!
JavaRocky