Window PARTITION BY Changes Results?!

PARTITION BY creates separate windows! Each partition has its own running sum. This partitioning will change your aggregation results!

#sql #sqltricks #partitionby #windowfunctions #runningsum #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #advancedsql

https://www.youtube.com/watch?v=OdUmjf_ZbSU