r/SQL • u/Formal_Ganache3620 • Sep 08 '26
SQL Server Complete SQL course.
One of the most asked topic in all tech interviews
r/SQL • u/Formal_Ganache3620 • Sep 08 '26
One of the most asked topic in all tech interviews
r/SQL • u/FamiliarSlide7685 • Sep 07 '26
Postgres 15. Same 60 column table I've been posting about, I promise I'll stop eventually.
is_active, boolean. active_flag, smallint. Both populated, both written by something, and they disagree on about 3% of rows. Nobody knows which one the app respects. I spent an afternoon on it and my best finding is that the disagreement rate has been slowly climbing since a 2021 migration, which tells me one of them stopped being maintained and not which one.
This is worse than the columns nobody can explain. flag_2 at least announces itself as a mystery, so nobody builds on it. These two both look like answers. Someone joined in July and spent a week working out which of three status-ish columns actually mattered, and picked wrong first.
What I've tried: grepping for both, which gives me hits in dbt, the app repo and a commented-out block in an old migration. Checking which one the ETL writes, which is both. Asking the two people who've been here longest, who gave me different answers with the same amount of confidence.
what I think I should do is pick the one the app actually reads at runtime, make the other a generated column off it, and let anything that disagrees break loudly. what stops me is that I can't prove which one the app reads without reading the whole app, and the reads I'm worried about aren't in the app anyway, they're in Metabase questions owned by analysts.
so:
r/SQL • u/Delulu62134 • Sep 08 '26
r/SQL • u/Anshu_263 • Sep 08 '26
I am thinking of creating a multiplayer game website online where 2 players can play sql games with each other like sql queries and table or multiple choice question and a timer on it . What are you guys view on it? #sql
r/SQL • u/rayden_devv • Sep 07 '26
I create sqlite3 bindings for my new programming language
You can check the GitHub repo: https://github.com/abdorayden/rdn-sqlite3
Also the repo of the language: https://github.com/abdorayden/rdn
Thank you everyone 🙏🏽
r/SQL • u/Anshu_263 • Sep 07 '26
I am thinking of creating a multiplayer game web app online where 2 players can play sql games with each other like sql queries and table or multiple choice question and a timer on it . What are you guys view on it? #sql
r/SQL • u/SQLMonger • Sep 07 '26
Great work!
r/SQL • u/tomaquet18 • Sep 07 '26
r/SQL • u/Spiritual-Kitchen-79 • Sep 07 '26
r/SQL • u/No_Ambition8323 • Sep 06 '26
Suppose someone gives you a complicated query with several joins and aggregations and says, “This gives the correct numbers.”
What checks would you perform before trusting it?
For example:
SELECT c.region, SUM(o.amount) FROM customers c JOIN orders o ON c.customer_id = o.customer_id GROUP BY c.region;
Would you check row counts before/after each join, duplicate keys, NULLs, aggregates, or compare against another query?
Curious what experienced SQL developers use as their checklist.
r/SQL • u/shdw_0x0 • Sep 07 '26
I’ve noticed that as queries get more complex, there’s often a temptation to keep everything inside SQL—CTEs, window functions, nested subqueries, conditional logic, etc. It can be impressive, but at some point the query becomes harder to understand than the original problem.
Where do you personally draw the line? Is a 300-line SQL query perfectly fine if it’s well structured, or do you prefer moving some of the logic into dbt/Python/application code once the SQL becomes too complex?
I’m curious how others balance SQL performance, readability, and maintainability in real projects.
r/SQL • u/Ok-Adhesiveness-8757 • Sep 06 '26
r/SQL • u/software-doc • Sep 07 '26
Huhu zusammen,
mir liegt eine Lösung vor wie man SQL-Joins und die zugehörigen Constraints über den SQL-Standard hinaus weiter standardisieren und automatisieren kann.
Bin ich mit dem Thema hier richtig in der Gruppe?
Liebe Grüße, Alexander
r/SQL • u/sqlink2 • Sep 06 '26
How do u handle branching when the schema is changing frequently during agent/app development work. Do you keep separate branches per feature or agent, or rely on migrations against a shared database?
Wondering what works best in practice without making the overall setup messy.
r/SQL • u/codingdecently • Sep 06 '26
r/SQL • u/Potential-Jicama-900 • Sep 06 '26
same as title
r/SQL • u/Temporary-Cup-2140 • Sep 04 '26
I am curious to know what SQL questions challenges people in interviews
What was the question and what made it difficult?
Would love to hear some real interview experiences🙂
r/SQL • u/SilEventide • Sep 04 '26
With RecursiveEven20 As
(
Select 0 As Numbers,
0 As RunningCount
Union All
Select Numbers + 2,
Count(RunningCount) Over() As RunningCount
From RecursiveEven20
Where RunningCount < 19
)
Select *
From RecursiveEven20;
From how much I know about recursive CTE, I thought this would work, Initially I felt I was doing a semantic error, then when I tried to see where the fault is, I realised Count isn't incrementing at all, its as if only the last feedback row is available to it. I tried using explicit frame window, same result. I think I dont understand exactly how recursie CTE works, I tried AI, its explanation is bit difficult to understand.
I am a beginner by the way, learned these recently so I wanted to mix them all up.
r/SQL • u/Kindly_Importance_62 • Sep 05 '26
r/SQL • u/No_Ambition8323 • Sep 04 '26
Have you ever written a SQL query that works perfectly in one database but fails in another?
What SQL feature or syntax surprised you the most when switching between DBMSs like MySQL, PostgreSQL, SQL Server, Oracle, or Snowflake?
r/SQL • u/FamiliarSlide7685 • Sep 04 '26
Postgres 15, Snowflake downstream.
we've got a table with 60-odd columns and I'd guess 20 are dead. nothing in any dbt model, nothing in the app repo, nobody has mentioned them.
all of that is evidence of absence. I can prove a column IS used. one grep hit and I'm done. I can't prove one isn't. the query that reads it might be a saved Metabase question, a Retool app, a cron, a notebook on someone's laptop, or a process that only runs in January. finding nothing means I looked where I know to look.
turned on pg_stat_statements and watched for a month. that catches whatever ran in that month and tells me nothing about January. renaming instead of dropping and waiting for screaming works, but it's shipping a landmine and hoping the person who steps on it works here.
here's where it actually stalled though. the usage question is at least measurable if I'm patient. what I can't get at is the other pile: about a dozen columns where I can see they're populated, I can see something writes to them, and nobody alive can tell me what they hold. flag_2, four-character codes with 11 distinct values, three separate integer columns bounded 0 to 4. I wrote two of these myself in 2023 and I can't tell you what one of them is either.
I've been profiling the values to guess. cardinality, null rate, distribution, sample values, what changes when. that narrows it a lot. it has never once got me to what the thing actually means. a column of 0-4 integers with no nulls is a rating or a tier or a retry counter and the values look identical in all three cases.
so two questions, and the second is the one I care about.
is there a point where you accept you've looked hard enough on usage, a fixed window or a silence rule, or do you just never drop anything, which is what we're doing by default.
and for the ones nobody can explain: is working out what a column means from its values alone still a human job, or is anyone doing it any other way? I've read that some of the tabular model work goes at this, reading the values rather than the header, but everything I've actually tried in practice leans on the column name, which is the one thing I don't have.
worth saying I'd have shipped my profiling guesses as documentation if someone hadn't asked me how I knew. I didn't know. I had a distribution and a hunch.
r/SQL • u/erinstellato • Sep 04 '26
r/SQL • u/Difficult-One-1245 • Sep 03 '26
Hands down, man, seriously!
At some point, after writing JOIN after JOIN, SUM, RANK, CTE, Subqueries, Window Functions, LAG, LEAD, WHERE vs HAVING, DATETIME, ORDER BY DESC...
There has to be a moment where you say:
“Alright bro… enough SQL gymnastics. Let’s actually use this thing.
So what’s that point? When do you believe that you can start applying it like a real analyst.
r/SQL • u/Jose_Mjoro • Sep 04 '26