5 ms·

HAVING COUNT(*) >= 2; Back to 10%

• elhudy 7y ago
  Add a date field or you might get legitimate duplicates if the payment amounts are the same across months.
  • TheSoftwareGuy 7y ago
    They shouldn't have the same transactionID then, no?
    • elhudy 7y ago
      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.