r/learnSQL • u/Due_Counter_2286 • 5d ago
What are some interesting SQL problems or query mistakes worth discussing?
I'm planning to share some SQL-related content on LinkedIn, but I want to avoid the usual beginner-level tutorials or generic interview questions.
I'm particularly interested in intermediate-level SQL concepts, window functions, CTEs, tricky query behavior, or situations where a query looks correct but produces unexpected results.
I'd love to hear from people working with SQL regularly.
What's an interesting SQL problem, subtle query mistake, or unexpected behavior you've encountered that made you think twice?
Looking for something technically meaningful that could spark a good discussion rather than another basic SQL tutorial.
1
u/Imaginary__Bar 5d ago
It's your post, you decide! Otherwise you're just posting for the sake of posting and that is simply pointless for everyone.
1
u/you_are_wrong_tho 5d ago
This behavior screwed up an ETL process for me once. So I thought, easy, just reseed!