ROODAY

      • Adding a new non-null column to an SQL existing table without dropping it
      • Adding a new web service to Engager
      • Bulk updating frontmatter
      • Docker + Traefik + Tailscale + Cloudflare
      • Good Interview Question
      • How are directories implemented by the OS
      • How to ask good SQL questions online
      • How to set up SSH Agent on Windows 10+
      • How to update an embed message with Carlbot
      • How to use Taskwarrior
      • New Hard Drive Burn-in Ritual
      • React Learnings
      • Remove files with filter in PowerShell
      • Scaling React Server Side Rendering
      • Scheduled Backups on Ubuntu using Duplicacy and Azure
      • Setting up a new shell on Ubuntu
      • Setting up Duplicacy on Ubuntu
      • Squash local commits when working with others
      • Waterfallgile
      • What's the best git branching strategy for web apps
        • Chicken Curry
        • Dad's Udon Noodles Recipe
        • Sacbe’s Beef Tacos
      • Bread Charlotte
      • Cast Iron vs. Carbon Steel
      • Ideas for this folder
      • Oregano
      • Pizza Dough
      • Surface Area
      • Causal Determinism
      • Credit Card Offers in the mail should be banned
      • Having friends at work is the greatest factor against attrition
      • How To Measure Utility
      • Life Is Not A Sprint, It's Comprised Of Sprints
      • We Can Implement Online Voting Now
          • As We May Think
          • Crypto is here to set us free
          • 1984
          • Atomic Habits
          • Books to read
          • Brave New World
          • Death's End
          • Dune
          • Ender's Game
          • Endymion
          • Hyperion
          • Manga In Theory And Practice
          • Ringworld
          • Sapiens
          • Slaughterhouse 5
          • Starship Troopers
          • Stop Reading the News
          • The Dark Forest
          • The Fall of Hyperion
          • The Martian
          • The Midnight Library
          • The Rise of Endymion
          • The Three-Body Problem
      • About Me
    Home

    ❯

    Coding

    ❯

    How to ask good SQL questions online

    How to ask good SQL questions online

    Feb 23, 20251 min read

    Main thing is making sure that people have example data. Having a table query that creates exmple tables (and therefore describes the schema), as well as some sample data to play around with along with queries and their expected outputs, is the best way to ensure getting the answer you need. E.g. https://stackoverflow.com/questions/70734268/sql-select-from-table-where-joined-values-from-a-second-table-are-a-subset-of-va


    Graph View

    Backlinks

    • No backlinks found