• Jeff Moden (10/25/2016)


    As a bit of a sidebar, it would have been nice if they had it default to a ROWS specification because it's faster than the RANGE specification.

    The reason that they used RANGE instead of ROWS is that RANGE is deterministic whereas ROWS is not when there are ties in the order by clause.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA