Moops@lemmy.worldEnglish · edit-28 months agoWhat are your thoughts on when to use LAST_VALUE() vs. MAX() KEEP(DENSE_RANK LAST ... )plus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareWhat are your thoughts on when to use LAST_VALUE() vs. MAX() KEEP(DENSE_RANK LAST ... )plus-squareMoops@lemmy.worldEnglish · edit-28 months agomessage-square0fedilink
Kafkacious@lemmy.world · 1 year agoBuilding a DIY ERP/Inventory Database?plus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareBuilding a DIY ERP/Inventory Database?plus-squareKafkacious@lemmy.world · 1 year agomessage-square0fedilink
ericbomb@lemmy.worldEnglish · 1 year agoWhen you're asked to write a custom query to be used in crystal reportsplus-squarelemmy.worldexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkWhen 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.worldexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkSQL Dev learning MongoDBplus-squarelemmy.worldDeadNinja@lemmy.world · edit-21 year agomessage-square0fedilink
DeadNinja@lemmy.world · 2 years agoNoSQL keeps rising, but relational databases still dominate big dataplus-squarewww.techrepublic.comexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkNoSQL keeps rising, but relational databases still dominate big dataplus-squarewww.techrepublic.comDeadNinja@lemmy.world · 2 years agomessage-square0fedilink
requiem@lemmy.worldEnglish · edit-22 years 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-22 years agomessage-square0fedilink
pahakala@lemmy.world · 2 years 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 · 2 years agomessage-square0fedilink
biofaust@lemmy.world · 2 years agoAre there patterns one learns to solve SQL interview questions (or tasks in general)?plus-squaremessage-squaremessage-square3fedilinkarrow-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-square3fedilink
pahakala@lemmy.worldEnglish · 2 years agoYour favorite database engine?plus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareYour favorite database engine?plus-squarepahakala@lemmy.worldEnglish · 2 years agomessage-square0fedilink
Shertson@lemmy.worldM · 2 years 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 · 2 years agomessage-square0fedilink
Shertson@lemmy.worldM · 2 years 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 · 2 years agomessage-square0fedilink
Shertson@lemmy.worldM · 2 years 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 · 2 years agomessage-square0fedilink
Shertson@lemmy.worldM · 2 years agoAnnouncing SQL Communityplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareAnnouncing SQL Communityplus-squareShertson@lemmy.worldM · 2 years agomessage-square0fedilink
