Thread: Find duplicate entries in a table?
View Single Post
  #2 (permalink)  
Old 04-17-2006, 01:38 AM
ben ben is offline
Administrator
  
Join Date: Mar 2007
Posts: 87
ben has disabled reputation
Default SQL 92 answer. Re: Find duplicate entries in a table?
Let's assume we want to find duplicate emails in a 'users' table:

[sql]
SELECT id, email, count(email) FROM users GROUP BY email HAVING count(email) > 1
[/sql]
Reply With Quote