3 ms·
Off topic: does any other here have trouble with queries like this? Rank the employees according to their salaries in each department My SQL is “good” I t
by tkiolp4 3y ago
Off topic: does any other here have trouble with queries like this?
Rank the employees according to their salaries in each department
My SQL is “good” I think, but to be honest in my day to day I usually don’t deal with aggregation nor windowed queries (my BI colleagues are masters are those, though )
- nalgeon 3y agoYou'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