Eight window-function tricks beyond LAG and ROW_NUMBER
The first post in this series got more reader response than I expected. The comments were full of practical follow-up questions and a few good correct…
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devchallenge
devops
gemma
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
tutorial
typescript
webdev
Six SQL patterns I use to catch transaction fraud
Quick disclaimer: I do data work on a program-integrity team. Examples below use generic transaction tables and made-up scenarios. Nothing here comes …