testeronious@lemmy.world to Programming@programming.dev · 11 months agoWhy most developers stop learning SQL at subqueries - a 5-minute guide for PARTITION BY and CTEszaidesanton.substack.comexternal-linkmessage-square14fedilinkarrow-up1126arrow-down14
arrow-up1122arrow-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 · 11 months agomessage-square14fedilink
minus-squaremvirts@lemmy.worldlinkfedilinkarrow-up17arrow-down1·11 months agoI feel like the word “partitions” used in this article should be “window functions”
minus-squareGBU_28@lemm.eelinkfedilinkEnglisharrow-up3·11 months agoGood point. Window functions are mandatory knowledge for intermediate users
I feel like the word “partitions” used in this article should be “window functions”
Good point. Window functions are mandatory knowledge for intermediate users