Post #2568798

For the #SQL & finance nerdery folks, this was an good writeup¹ of fraud-detection using SQL, providing actual queries with technical explanations. I'll grant, the audience for the post is pretty niche, but if you're an aspiring SQL dev, it has some strong examples using window-functions (including named window-functions² which I don't often see in the wild, since it's only become more available in the last 5 years or so). ⸻ ¹ https://analytics.fixelsmith.com/posts/sql-fraud-patterns/ ² https://modern-sql.com/caniuse/window_clause