testeronious@lemmy.world to Programming@programming.dev · 7 months agoWhy most developers stop learning SQL at subqueries - a 5-minute guide for PARTITION BY and CTEszaidesanton.substack.comexternal-linkmessage-square18fedilinkarrow-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 · 7 months agomessage-square18fedilink
minus-squareLmaydev@programming.devlinkfedilinkarrow-up3·edit-27 months agoJoining is one of the simplest and most useful things in SQL. How can you possibly query without it? Simple queries are obviously better but not everything can be achieved with simple selects.
Joining is one of the simplest and most useful things in SQL.
How can you possibly query without it?
Simple queries are obviously better but not everything can be achieved with simple selects.