How to Find Duplicate Rows in SQL (and Decide What Counts as One)

The GROUP BY HAVING pattern that lists every duplicate, a ten-second COUNT test for any table, and why analysts mark extras instead of deleting them.