Thread: List all customers whose name is present more than once in the table?
View Single Post
  #2 (permalink)  
Old 05-24-2006, 12:01 AM
alexfr alexfr is offline
Junior Member
  
Join Date: May 2006
Posts: 24
alexfr is on a distinguished road
Default MySQL answer. Re: List all customers whose name is present more than once in the table?
[sql]SELECT count(*), name
FROM customers
GROUP BY name
HAVING (count(*)>=2)[/sql]
Reply With Quote