Hacker News new | ask | show | jobs
by madenine 2376 days ago
HAVING COUNT(*) >= 2;

Back to 10%

1 comments

Add a date field or you might get legitimate duplicates if the payment amounts are the same across months.
They shouldn't have the same transactionID then, no?
Wouldn't think so. Each transaction ID would represent a unique transaction?

>Other double payments made by mistake included times that the state received multiple invoices.

I would assume each paid invoice was a new transaction ID. The real problem seems like there are two invoices being paid. Not that there are two transactions (which seems like just a symptom). It's possible that each invoice even has it's own ID.