5SQL Anti‑Patterns and How to Fix Them slicker.mec/sql · by monica_b1998@lemmy.world · 162d · 0 comments
7What are your thoughts on when to use LAST_VALUE() vs. MAX() KEEP(DENSE_RANK LAST ... ) c/sql · by Moops@lemmy.world · 2y · 2 comments
16When you're asked to write a custom query to be used in crystal reports c/sql · by ericbomb@lemmy.world · 2y · 0 comments
11NoSQL keeps rising, but relational databases still dominate big data techrepublic.comc/sql · by DeadNinja@lemmy.world · 2y · 0 comments
1Graphical SQL Editor with auto-complete for Relational Tables? c/sql · by requiem@lemmy.world · 3y · 3 comments
4Create an advanced search engine with PostgreSQL xata.ioc/sql · by pahakala@lemmy.world · 3y · 1 comments
2Are there patterns one learns to solve SQL interview questions (or tasks in general)? c/sql · by biofaust@lemmy.world · 3y · 4 comments
3Best practices for writing SQL (according to metabase) metabase.comc/sql · by shertson@lemmy.world · 3y · 0 comments
2Ask complex questions of high-volume real-time data streams github.comc/sql · by shertson@lemmy.world · 3y · 0 comments
3SQL:2023 is finished: Here is what's new (Peter Eisentraut) peter.eisentraut.orgc/sql · by shertson@lemmy.world · 3y · 0 comments
