• cengland0 (1/6/2011)


    There are several ranking functions:

    . . . One row is still a non empty rowset but that was not explained in the provided explanation.

    You are absolutely right. Thank you for pointing out this boundary case.

    In my defense, I am still doing better than SQLS BOL which are not mentioning an empty set.

    😉