Select duplicate record

You get get all duplicates with this query:

SELECT company, acct, count(*) AS Cnt
FROM yourTable
GROUP BY company, acct
HAVING count(*) > 1

---

Olaf Helper

[ Blog] [ Xing] [ MVP]