Aug 8, 2012

Find Duplicate Records in a Table

In some cases you need to locate if there are duplicate record in a table and you are stuck how to go about, then here's how you can find it.

SELECT cellno, COUNT(cellno) AS NumOccurrences
FROM tblClientCellNumber
GROUP BY cellno
HAVING (COUNT(cellno) > 1)

No comments:

Post a Comment