testeronious@lemmy.world to Programming@programming.dev · 9 months agoWhy most developers stop learning SQL at subqueries - a 5-minute guide for PARTITION BY and CTEszaidesanton.substack.comexternal-linkmessage-square14fedilinkarrow-up1125arrow-down14
arrow-up1121arrow-down1external-linkWhy most developers stop learning SQL at subqueries - a 5-minute guide for PARTITION BY and CTEszaidesanton.substack.comtesteronious@lemmy.world to Programming@programming.dev · 9 months agomessage-square14fedilink
minus-squarehowrarlinkfedilinkarrow-up9·9 months agoIt’s always bothered me when I write subqueries that have to be run on each row. Good to know that there’s a better way.
It’s always bothered me when I write subqueries that have to be run on each row. Good to know that there’s a better way.