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