SELECT id, policy_number, count(*) FROM `policies` group by policy_number having ( count(*) > 1 and id >10000) SELECT submission_date, policy_number, count(*) FROM `policies` group by policy_number having ( count(*) > 1 and submission_date = ’2015-11-20’)

By michael