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.
😎