- postgresql ·
- sql ·
- ·
- ·
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 credited a payment, and now a credit, to ACME Inc #2. I ran…
- BTS·
- October 11, 2011 4:52 pm·