4 ms·

HAVING COUNT(*) > 2; I'll take 9% );

• mgraczyk 7y ago
  `>=` 8%?
• madenine 7y ago
  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.