DISTINCT & Removing Duplicates: Interview

Why can DISTINCT hide a join defect?

DISTINCT removes duplicate result rows after the join. It can conceal an unintended many-to-many join without correcting the join condition or the duplicated aggregation grain.

Fix cardinality at its source before using DISTINCT as a presentation requirement.