• Nice question - thanks steve

    Did a bit of digging...as another explanation

    https://www.simple-talk.com/sql/learn-sql-server/window-functions-in-sql-server-part-2-the-frame/

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective