Bob, You have to do a self join - try this off the top of my head... -
Select p1.email FROM tblperson p1, tblperson p2 WHERE p1.email = p2.email GROUP BY p1.email HAVING count(p1.email) > 1 Andy > -----Original Message----- > From: Bob Sawyer [mailto:[EMAIL PROTECTED] > Sent: 01 April 2003 21:04 > To: MySQL List > Subject: Opposite of DISTINCT() > > > I know that using SELECT DISTINCT(colname) will result in output that does > not contain any duplicates from that column. But how would I > output JUST the > duplicates? If I have as part of a table a column containing email > addresses, and I want to list just the duplicate addresses rather than the > distinct addresses, what's the syntax there? > > Thanks, > Bob > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
