• ScottPletcher (12/26/2014)


    I don't understand the point of:

    "PARTITION BY (SELECT NULL)"

    in the LAG. Why not just leave out "PARTITION BY"?

    It's a habit which comes from the strange over clause defaults, better to explicitly state it than implicitly apply it, makes the code even more self explanatory.

    😎