tag:blogger.com,1999:blog-3930626737213165021Sat, 31 Aug 2024 05:42:39 +0000http://code4project.blogspot.com/noreply@blogger.com (Pankaj Deharia)Blogger1125en-usnonoreply@blogger.comtag:blogger.com,1999:blog-3930626737213165021.post-8704490903867517054Sat, 11 Apr 2009 15:26:00 +00002009-04-11T08:29:24.373-07:00SELECT email, <br /> COUNT(email) AS NumOccurrences<br />FROM users<br />GROUP BY email<br />HAVING ( COUNT(email) > 1 )<br />You could also use this technique to find rows that occur exactly once:<br />SELECT email<br />FROM users<br />GROUP BY email<br />HAVING ( COUNT(email) = 1 )http://code4project.blogspot.com/2009/04/finding-duplicates-with-sql.htmlnoreply@blogger.com (Pankaj Deharia)0