Home Forums Article Discussions Article Discussions by Author Discuss content posted by Revenant RANK() returns consecutive integers RE: RANK() returns consecutive integers

  • January 6, 2011 at 2:09 am

    #1269928

    There are several ranking functions:

    RANK

    DENSE_RANK

    NTILE

    ROW_NUMBER

    When the question asked will it always return consecutive integers, I knew right away that it was false because none of them will always return consecutive integers if there is only one row. One row is still a non empty rowset but that was not explained in the provided explanation.