testeronious@lemmy.world to Programming@programming.dev · 8 months agoWhy most developers stop learning SQL at subqueries - a 5-minute guide for PARTITION BY and CTEszaidesanton.substack.comexternal-linkmessage-square7fedilinkarrow-up11arrow-down11
arrow-up10arrow-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 · 8 months agomessage-square7fedilink
minus-squarefmstrat@lemmy.nowsci.comlinkfedilinkEnglisharrow-up1·8 months agoHuh? How do you write an efficient query and not take into account joins? A single table query? Are you a Prisma fan?
Huh? How do you write an efficient query and not take into account joins? A single table query? Are you a Prisma fan?