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