You'd be surprised how useful they are once you've grokked them. I have a 4-part interactive tutorial on SQL window functions, if you are interested: https://a

You'd be surprised how useful they are once you've grokked them. I have a 4-part interactive tutorial on SQL window functions, if you are interested: https://antonz.org/sql-window-functions-ranking https://antonz.org/sql-window-functions-ranking