Moops@lemmy.worldEnglish · edit-21 year agoWhat are your thoughts on when to use LAST_VALUE() vs. MAX() KEEP(DENSE_RANK LAST ... )plus-squaremessage-squaremessage-square2linkfedilinkarrow-up18arrow-down11
arrow-up17arrow-down1message-squareWhat are your thoughts on when to use LAST_VALUE() vs. MAX() KEEP(DENSE_RANK LAST ... )plus-squareMoops@lemmy.worldEnglish · edit-21 year agomessage-square2linkfedilink
Kafkacious@lemmy.world · 2 years agoBuilding a DIY ERP/Inventory Database?plus-squaremessage-squaremessage-square2linkfedilinkarrow-up110arrow-down10
arrow-up110arrow-down1message-squareBuilding a DIY ERP/Inventory Database?plus-squareKafkacious@lemmy.world · 2 years agomessage-square2linkfedilink
ericbomb@lemmy.worldEnglish · 2 years agoWhen you're asked to write a custom query to be used in crystal reportsplus-squarelemmy.worldimagemessage-square0linkfedilinkarrow-up117arrow-down11
arrow-up116arrow-down1imageWhen you're asked to write a custom query to be used in crystal reportsplus-squarelemmy.worldericbomb@lemmy.worldEnglish · 2 years agomessage-square0linkfedilink
DeadNinja@lemmy.world · edit-22 years agoSQL Dev learning MongoDBplus-squarelemmy.worldimagemessage-square51linkfedilinkarrow-up1296arrow-down111
arrow-up1285arrow-down1imageSQL Dev learning MongoDBplus-squarelemmy.worldDeadNinja@lemmy.world · edit-22 years agomessage-square51linkfedilink
DeadNinja@lemmy.world · 2 years agoNoSQL keeps rising, but relational databases still dominate big dataplus-squarewww.techrepublic.comexternal-linkmessage-square0linkfedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkNoSQL keeps rising, but relational databases still dominate big dataplus-squarewww.techrepublic.comDeadNinja@lemmy.world · 2 years agomessage-square0linkfedilink
requiem@lemmy.worldEnglish · edit-22 years agoGraphical SQL Editor with auto-complete for Relational Tables?plus-squaremessage-squaremessage-square0linkfedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareGraphical SQL Editor with auto-complete for Relational Tables?plus-squarerequiem@lemmy.worldEnglish · edit-22 years agomessage-square0linkfedilink
pahakala@lemmy.world · 2 years agoCreate an advanced search engine with PostgreSQLplus-squarexata.ioexternal-linkmessage-square0linkfedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkCreate an advanced search engine with PostgreSQLplus-squarexata.iopahakala@lemmy.world · 2 years agomessage-square0linkfedilink
biofaust@lemmy.world · 2 years agoAre there patterns one learns to solve SQL interview questions (or tasks in general)?plus-squaremessage-squaremessage-square4linkfedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareAre there patterns one learns to solve SQL interview questions (or tasks in general)?plus-squarebiofaust@lemmy.world · 2 years agomessage-square4linkfedilink
pahakala@lemmy.worldEnglish · 2 years agoYour favorite database engine?plus-squaremessage-squaremessage-square0linkfedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareYour favorite database engine?plus-squarepahakala@lemmy.worldEnglish · 2 years agomessage-square0linkfedilink
Shertson@lemmy.worldM · 2 years agoBest practices for writing SQL (according to metabase)plus-squarewww.metabase.comexternal-linkmessage-square0linkfedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkBest practices for writing SQL (according to metabase)plus-squarewww.metabase.comShertson@lemmy.worldM · 2 years agomessage-square0linkfedilink
Shertson@lemmy.worldM · 2 years agoAsk complex questions of high-volume real-time data streamsplus-squaregithub.comexternal-linkmessage-square0linkfedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkAsk complex questions of high-volume real-time data streamsplus-squaregithub.comShertson@lemmy.worldM · 2 years agomessage-square0linkfedilink
Shertson@lemmy.worldM · 2 years agoSQL:2023 is finished: Here is what's new (Peter Eisentraut)plus-squarepeter.eisentraut.orgexternal-linkmessage-square0linkfedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkSQL:2023 is finished: Here is what's new (Peter Eisentraut)plus-squarepeter.eisentraut.orgShertson@lemmy.worldM · 2 years agomessage-square0linkfedilink
Shertson@lemmy.worldM · 2 years agoAnnouncing SQL Communityplus-squaremessage-squaremessage-square0linkfedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareAnnouncing SQL Communityplus-squareShertson@lemmy.worldM · 2 years agomessage-square0linkfedilink
