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-up1122arrow-down14
arrow-up1118arrow-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-squareAngryishHumanoid@reddthat.comlinkfedilinkarrow-up14·9 months agoI imagine it depends on use case. Anything more advanced that subqueries/CTEs is largely the domain of ETL developers (not exclusively, obviously) but most others using SQL don’t need anything that advanced.
I imagine it depends on use case. Anything more advanced that subqueries/CTEs is largely the domain of ETL developers (not exclusively, obviously) but most others using SQL don’t need anything that advanced.