Data Coding

Lesson 13.2 · Pro

Debugging a wrong answer

Five quick checks that catch most wrong results, each with a broken query to fix.

In this lesson

  1. 1. Check row counts after each step
  2. 2. Check for whole-number division
  3. 3. Check the date boundaries
  4. 4. Check where outer-join filters sit
  5. 5. Check window frames