Finding duplicate records in a database: the SQL HAVING clause
One issue I run across occasionally is a table with duplicate entries such as two entries for the same company in an accounts payable system. This can create embarrassing problems with billing if ACME Inc #1 is 90 days overdue because someone posted a payment, and now a credit, to ACME Inc #2. I ran […]
Finding duplicate records in a database: the SQL HAVING clause Read More »