Finding Duplicates with SQL Posted on December 7, 2017 by Chandan Sharma in PHP, SQLFinding Duplicates with SQL:: SELECT `email`, COUNT(`email`) AS NumOccurrences FROM `user` GROUP BY `email` HAVING ( COUNT(`email`) > 1 )Share this:TwitterFacebook Published by Chandan Sharma View all posts by Chandan Sharma