1
SQL patterns I use to catch transaction fraud
The actual queries I run when I'm hunting fraud in transaction data. Velocity, impossible distances, suspicious amounts, merchant clusters, off-hours buys, and window functions.
Practical SQL, fraud detection, and public-sector data work — by an experienced Program Integrity Analyst.
Visit analytics.fixelsmith.com → RSS feedOn Hacker News May 2026 – May 2026
The actual queries I run when I'm hunting fraud in transaction data. Velocity, impossible distances, suspicious amounts, merchant clusters, off-hours buys, and window functions.