A tied ORDER BY still leaves part of the order unspecified
A stable list needs a final ordering key that distinguishes otherwise equal rows.
Wildness 1/5 · Tamed
Topic · 6 stories
data-quality
6 stories tagged data-quality on AI Tamer, newest first.
UNION removes duplicate rows that UNION ALL preserves
Combining two result sets needs a decision about whether repeated values represent repeated events.
Wildness 1/5 · TamedA running total needs a deliberate window frame
Rows with the same ordering key can share a cumulative result unless the frame says otherwise.
Wildness 1/5 · TamedPut missing values where the reader expects them
Explicit NULL ordering makes a ranked list easier to understand and maintain.
Wildness 1/5 · TamedCOUNT(column) skips rows whose value is NULL
A dashboard count needs to say whether it measures records or populated fields.
Wildness 1/5 · TamedSQLite UNIQUE allows more than one missing value
A uniqueness rule on an optional field does not also require that field to be present.
Wildness 1/5 · Tamed
